Manage Data with Tables
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.