An Excel Table is a special structure for managing information in lists or tables. To quickly create an Excel Table, select any cell in the data, and use the keyboard shortcut control + T. Links to video demos appear below this article.
Key advantages to Excel Tables
Compared to manually formatted tables, Excel Tables have several key advantages:
Structured data - data appears in rows and columns without spaces. This makes it easy to work with the data like a database.
Automatic formulas - new rows "inherit" existing formulas, and changes to an existing formula automatically propagates throughout a column.
Filters - although filters can be applied to any normal table, they are automatically available in an Excel Table.
Automatic formatting and styles - Tables can be rapidly formatted using Table Styles, and new data added to Excel Table inherits this formatting.
Structured references - structured references make it easy to refer to table rows and columns without specific cell references.
Enhanced shortcuts - shortcuts for manipulating rows and columns work better with Excel Tables. See this video for a demonstration.
Dynamic ranges - Excel tables automatically expand to include new rows, so they behave like dynamic ranges, and are perfect for things like charts and pivot tables.
A structured reference is a special syntax for referencing Excel Tables . Structured references work like regular cell references in formulas, but they are easier to read and understand. Structured references are also dynamic, and adjust...