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

Ask Your Question

Excel-like tables that add new rows and replicate formulas

asked 2017-12-31 06:49:36 +0200

Rob Hines gravatar image

updated 2020-10-25 12:48:03 +0200

Alex Kemp gravatar image

I'm hoping this capability is not unique to Excel... This question has been asked about Google Sheets also with negative results:

In Excel you are able to take a range of cells and convert it to a Table which has the following benefits:

  • Banded row
  • Filterable columns
  • Functions in columns are automatically applied as new rows of data are entered
  • Range becomes a dynamic named range that grows as new rows/columns are added
    • PivotTables that reference this source table's columns automatically adjust as new rows are added
    • Aggregating functions like Sum() & Average() automatically adjust to the number of rows.

Is there a way to turn a selected range into a dynamic Table?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2021-01-04 22:03:16 +0200

Unfortunately, I believe this capability is unique to Excel. I use Excel and LibreOffice Calc interchangeably, and recently discovered this limitation. There are other posts that ask similar questions. Regrettably, I have not found a solution. I release this post is a bit old, but thought I would update it. I find great value in this Excel capability and hope it will one day make it into Calc.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools



Asked: 2017-12-31 06:49:36 +0200

Seen: 358 times

Last updated: Jan 04