Where are the Table Tools?

The Table Tools aren’t available on the ribbon in Excel Online, so you won’t be able to use them to make design changes to your table.

Though Excel Online doesn’t have Table Tools, some of the options are available. Here’s where you can find them:

  • Refresh data connections: Click any cell in the table > Data and pick either Refresh Selected Connection or Refresh All Connections.

  • Toggle total and header rows: Click any cell in the table > Format as table and choose one of the toggle options.

If you have the Excel desktop application, you can open your worksheet there and use the Table Tools to make design changes. Here’s how:   

  1. Click Open in Excel.

       Open in Excel button

  2. Click any cell in the table and Table Tools becomes available. You can use the Design options to make changes to the table.

    Table Tools in the Ribbon

  3. When you save the workbook and reopen it in Excel Online, you'll see the design changes you made.  

If you don't have the Excel desktop application, you can give it a try. Or you can buy it here, when you're ready to switch.   

For news about the latest Excel Online updates, visit the Microsoft Excel blog. 

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!