Spreadsheet Tips

Manage Data with Tables

September 17, 2019
A person selects some data and clicks the "Table" button, transforming it into a table that can be sorted and filtered.

A table is a special type of data format in Excel. It adds a bit of structure to your data, allowing you to sort, filter, and reorganize your data in interesting ways. It even adds some instant formatting, providing a bunch of colorful themes you can choose from.

To add a table, select your data (including headers) and click the Table icon on the Insert tab. This will create a table, format it, and add dropdown icons to the headers for filtering and sorting.

Whenever you select part of your table, you'll also see a "Tables" tab, which contains a bunch of settings and formats that you can apply to your table.