Create a table

When you create a table format for the data on your worksheet, you can perform calculations or filter and sort that data without affecting other data on the worksheet.

To add a blank table, select the cells you want included in the table and click Insert > Table.

To format existing data as a table by using the default table style, do this:

  1. Select the cells containing the data.

  2. Click Home > Format as Table and choose Format as Table.

    Button to format data as a table

  3. If you don’t check the My table has headers box, Excel Online adds headers with default names like Column1 and Column2 above the data. To rename a default header, double-click it and type a new name.

Note: You can’t change the default table formatting in Excel Online.

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!