By turning an Excel range into a table, you can work with the table data independently from the rest of the worksheet, and filter buttons appear automatically on the column headers, allowing you to filter and sort columns even faster. You can also add total rows and quickly apply table formatting.
If you already have an organized range of data, you can turn it into a table. Before turning a range of data into a table, remove blank rows and columns, and make sure that a single column doesn’t have different types of data within it.
Click a cell in the range you want to convert to a table.
Click the Format as Table button on the Home tab.
Select the table style you want to use.
You can also click the Insert tab on the Ribbon and click the Table button in the Tables group.
Verify the data range includes all the cells you want to include in the table.
Make sure to specify whether the table has a header row. If it doesn’t, Excel will add a header row above the table data.
The table is created. Filters are added to each column and the table is automatically formatted. Under Table Tools on the Ribbon, the Design tab appears.