Discussion on:

Message 2 of 9
0 Votes
+ -
It is formatted as a table
The range she is trying to sort is formatted as a table. She will have to go to the Table Tools tab, Tools group, and Select "convert to range" to use subtotals. She cannot use both the subtotals and the table formatting.

The "blue" clue refers to the formatting that is applied by default when formatted as a table.
Posted by adundon
21st Jun 2011