Excel Table

AnExcel Tableis a special object for managing data in Excel.

Excel Tables have a name which appears in thename boxwhen the entire table is selected.

For a complete introduction to Excel Tables see:Excel Tables.

This makes it easy to work with the data like a database.

Filters- although filters can be applied to any normal table, they are automatically available in an Excel Table.

Structured references-structured referencesmake 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.