M365 Excel - Create and format tables

Note: Excel tables shouldn't be confused with the data tables that are part of a suite of What-If Analysis commands (Forecast, on the Data tab). See Introduction to What-If Analysis for more information.

1. Select a cell within your data.
2. Select Home > Format as Table.
3. Choose a style for your table.
4. In the Create Table dialog box, set your cell range.
5. Mark if your table has headers.
6. Select OK.