How do I select subtotal for a list when it is in grey?

S

Student05

I would like to create a nested subtotal for my list. The problem is...the
Subtotal command in the Data is not activated and is shown in grey. How does
the Subtotal command activate? My list is already sorted.
 
W

WendyUK

Hi Student05,

First check that your worksheet is NOT protected. Then highlight the
values/rows/columns you wish to subtotal and the option will appear.

WendyUK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup a subtotal 2
Don't show all Pivot table subtotals 1
Problem with subtotal function 0
Additonal info into newly created Subtotal row 1
subtotal, match? 10
Import external data into Excel 2007 so I can subtotal it 2
Macro Pause to Select range then Subtotal 0
Excel 2007 - Outline not displaying all nested subtotals 0

Top