Because Excel’s worksheet grid is already structured as rows and columns, many people define data that is structured in a row-column-grid format as a Table.

But…in Excel, a Table is much more than a description of data structure. Storing your list based data as Table brings some real time-saving benefits, especially if more data is added to the list on a regular basis.

Learn more in this video. Links to the video and individual sections below:


What is a Table?

Automatic Resizing

Using Table Structured References in a Formula

Base a Pivot Table on a Table

Base a Chart on a Table

Formulas Within Tables

Column Headings Remain Visible

Slicers in Tables

Creating a Table