How to Insert 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

This tutorial shows how to insert a table in Microsoft Excel by selecting a cell range, using the Insert tab, and confirming settings in the Create Table dialog. Converting data to an Excel table unlocks built-in filtering, sorting, and table styles that make spreadsheet management faster and more structured.

Steps

Select the cell range you want to include in the table.
Go to the Insert tab and click Table.
In the Create Table dialog, confirm the range and check My table has headers if applicable, then click OK.
Choose a table style from the available options to format your table.

📌 Why this matters

Knowing how to insert a table in Microsoft Excel is a foundational spreadsheet skill that unlocks powerful built-in features such as automatic filtering, structured references, and dynamic sorting. Excel tables automatically expand as you add new data, keeping formulas and formatting consistent without manual adjustment. For anyone working with datasets, reports, or dashboards, converting a plain cell range into an Excel table dramatically reduces formatting errors and speeds up data analysis. This interactive demo makes it easy to learn the exact steps — from selecting your data to applying a table style — in just minutes.

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