# How to Make a Table in Microsoft Excel

> 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.

Canonical: https://livedemo.ai/tutorials/how-to-make-a-table-in-microsoft-excel/
Apps: Microsoft, Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a48d0ab56e05a00ff3b64/preview?step=1

## Steps

1. Select the cell within your data.
2. Click on the Home tab in the ribbon, then click Format as Table and choose a style for your table.
3. In the Format As Table dialog, confirm the range, check "My table has headers" if applicable, and click OK .
4. Your data is now formatted as a table with filtering and styling options.