We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

[Calc] - Alternative to "Format As Table" feature in Excel 2007/2010/2013 [closed]

asked 2013-03-24 22:26:46 +0200

Yuriy Samorodov gravatar image

updated 2013-03-24 22:28:51 +0200

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:


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

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-01 21:59:45.497597


See also same question here. However I think the best answer is here from @Goran Rakic

loved.by.Jesus gravatar imageloved.by.Jesus ( 2019-03-14 09:53:35 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-05-26 15:38:08 +0200

At the moment you need to do this step by step: create named ranges, add autofilter and use autoformat for style.

There is a Google Summer of Code idea proposal for implementing ranges/formula features. While right now there is no ongoing development, one could use the pointers from the proposal to develop or fund the development of such feature.

edit flag offensive delete link more

Question Tools



Asked: 2013-03-24 22:26:46 +0200

Seen: 30,898 times

Last updated: May 26 '13