5 ms·

Excel 2007 solved the naming problem with tables. You can refer to cells in the same row, or an entire column or range of columns. https://support.office.com/en

Excel 2007 solved the naming problem with tables. You can refer to cells in the same row, or an entire column or range of columns. https://support.office.com/en-gb/article/Using-structured-references-with-Excel-tables-f5ed2452-2337-4f71-bed3-c8ae6d2b276e https://support.office.com/en-gb/article/Using-structured-re... Edit: and of course individual cells can be renamed since forever.

mschaef 9y ago
Data tables can also make things considerably faster. A colleague of mine once made a spreadsheet something like an order of magnitude faster by switching to data tables. (Maybe more speedup than that, even.)
cm2187 9y ago
Assuming all you ever care about is tabular data. If you are building a business plan in Excel, or trying to explain how the financial accounts consolidates in a large organisation with multiple subsidiaries, tables are not particular useful. That's the catch with Excel. One application, thousands of very different use cases.
- addicted 9y ago
  So how do named columns help with non-tabular data?
  - cm2187 9y ago
    That's my point, they don't. If your table is a complex calculation, not data, named columns don't help you.