Formatting Tables

Formatting Excel tables can improve how your spreadsheet looks. Use the table function in Excel to also better organize content.

Formatting tables

To format information as a table:

Format as Table
Format as Table Dialog Box

By default, the table will be set up with the drop-down arrows in the header so you can filter the table if you wish.

In addition to using the Format as Table command, you can select the Insert tab and click the Table command to insert a table.