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.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×