Frage stellen

Yuriy Samorodov's Profil - Aktivität

2019-04-05 15:17:36 +0100 verliehene Abzeichen  Fragen (Quelle)
2018-02-08 00:43:24 +0100 verliehene Abzeichen  Schüler (Quelle)
2013-10-21 23:23:46 +0100 verliehene Abzeichen  Elementare Frage (Quelle)
2013-10-21 23:23:46 +0100 verliehene Abzeichen  Bemerkenswerte Frage (Quelle)
2013-10-21 23:23:46 +0100 verliehene Abzeichen  populäre Frage (Quelle)
2013-03-24 22:27:47 +0100 verliehene Abzeichen  Redakteur (Quelle)
2013-03-24 22:26:46 +0100 Gestellte Frage [Calc] - Alternative to "Format As Table" feature in Excel 2007/2010/2013

Hello Community!

There is a great feature in Excel 2007 an newer: Format as Table. It comes handy because with 3 clicks it does the following:

  1. Format headings and cells with data, applies borders and makes spreadsheet look very professional
  2. Applies a name to a the table making it a Dynamic named range as a whole.
  3. Makes each column a named range
  4. You may call each cell by its name like:

    =vlookup([@SearchTerm],TableToSearchIn[#All],1,0)

Here is a great video covering this feature in Excel: Excel 2010 Table Formatting

So the question is: Is there any way to do the same thing in LibreOffice Calc?

Thank you, Yuriy