What's the difference between a Table and a Named Range in Excel 2007?
- by technomalogical
Can someone explain the difference between 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.
Other questions:
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.
