Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

If the Subtotals command is grayed out, that’s because subtotals can’t be added to tables. But there’s a quick way around this. Convert your table to a range of data. Then you can add subtotals.

Just remember, converting to a range takes away the advantages of a table. Formatting, like colored rows, will remain, but things like filtering will be removed.

  1. Right-click a cell in your table, point to Table, and then click Convert to Range.

Table option on the right-click menu

  1. Click Yes in the box that appears.

Confirmation dialog box

Add subtotals to your data

Now that you’ve removed the table functionality from your data, you can add your subtotals.

  1. Click one of the cells containing your data.

  2. Click Data > Subtotals.

  3. In the Subtotals box, click OK.


    • Once you’ve added your subtotals, an outline graphic appears to the left of your data. You can click on the number buttons along the top of the graphic to expand and collapse the data.

    • Data with subtotals included

    Tip:  If you decide you don’t want subtotals, you can remove them by clicking anywhere in the data, clicking Data > Subtotals, and then in the Subtotals box, click Remove All.

Remove All option in the Subtotals box

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?

Thank you for your feedback!