View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Subtotals in a list

If you have a cell in the list selected, you should be able to just click on the
Subtotal icon on the List Toolbar (show that toolbar if you need to).

But using ranges (not lists), data|subtotals and autofilters don't work well
with each other.

That could be why data|subtotal is disabled for Lists.

Bagheera wrote:

On my worksheet I have used the 'Create List' command for the data. However,
in this mode, the Subtotals function on the Data menu is greyed out. In order
to add subtotals, I have to convert the list to a range. Surely it's possible
to add subtotals within a list? What am I missing?

Thanks.


--

Dave Peterson