How to Make a Table in Microsoft Excel

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to create and format 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

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

📌 Why this matters

Converting a data range into a structured Excel table is one of the most efficient ways to manage and analyze data in Microsoft Excel. Excel tables automatically enable column filtering, dynamic range expansion, and consistent styling, saving users significant manual formatting time. This feature is essential for anyone working with datasets who needs reliable sorting, filtering, and formula referencing built in from the start. Learning to use Format as Table correctly ensures your spreadsheets are both visually organized and functionally powerful.

Your product deserves an interactive demo

Start free

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel