There is a great feature in Excel 2007 an newer: Format as Table.
It comes handy because with 3 clicks it does the following:
Format headings and cells with data, applies borders and makes spreadsheet look very professional
Applies a name to a the table making it a Dynamic named range as a whole.
Makes each column a named range
You may call each cell by its name like:
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?