Can someone explain the difference between Excel Tables and Named Ranges in Excel 2007? It seems that in addition to having the features of Named Ranges, they're somehow marked as Tables which gives them special formatting & filtering options in the ribbon.
- Can I treat a table as a named range?
- Does a named range provide me any functionality not offered by a table, and vice versa?
- Should I use one over the other (assuming that consumers of the spreadsheet are using Excel 2007 or higher)?
Google has not been helpful (
excel difference between named range and table and
excel 2007 difference between named range and table), and I've found one resource describing table functionality, but no reference to named ranges.
EDIT: It seems that the primary difference is the ability to use structured references. There's also the ability to easily re-size the dimensions of the table, and to insert new columns without moving an entire column, though those last two are only from my observations.