How to Make a Table in Microsoft Excel
- George Apostolov
How to Make a Table in Microsoft Excel: step-by-step guide
Select the cell within your data.
Click on the Home tab in the ribbon, then click Format as Table and choose a style for your table.
In the Format As Table dialog, confirm the range, check "My table has headers" if applicable, and click OK.
Your data is now formatted as a table with filtering and styling options.
Quick answer: To make a table in Microsoft Excel, first select a cell within your data. Next, click the Home tab, select Format as Table, and choose a style. Finally, confirm the range in the dialog, check the header option if needed, and click OK to apply filtering and styling.
About this Microsoft tutorial
Format your data quickly into a table in Microsoft by selecting a cell, choosing a table style from the Home tab, and confirming your range. This guide shows how to make a Table in Microsoft Excel in 4 steps, starting with "Select the cell within your data" and finishing with "Your data is now formatted as a table with filtering and styling options". The interactive demo above is a click-through copy of the real Microsoft interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to make a Table in Microsoft Excel?
4 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Microsoft data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Microsoft and Excel. Related guides: How to make cells fit text microsoft excel, How to Make Gridlines Darker in Microsoft Excel and How to Make Planner Pages in Microsoft Word. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
