How to Make a Table in Microsoft Excel

Guide

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.