How to Make a Table in Microsoft Excel

Quick summary

Creating a table in Microsoft Excel lets you instantly apply filtering, sorting, and structured styling to your data. Use the Format as Table feature in the Home tab to convert any data range into a fully functional Excel table in seconds.

Steps

1. Select a cell within your data range to begin the table creation process.
2. Click the Home tab in the ribbon, then click Format as Table and choose a table style.
3. In the Format As Table dialog, confirm the data range, check "My table has headers" if your data includes column headers, then click OK.
4. Your data is now formatted as an Excel table with built-in filtering and styling options ready to use.