View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Removeing the Grand Total Line when subtotals are removed

I'd try removing those subtotals once more.

Make sure you select the entire range before you do it, though.



Melody wrote:

I have Excel 2003. I have a spreadsheet that I have run subtotals on.
However, when I do Remove All to remove the subtotals the grand total and the
+- bar is still there.

How can I get rid of all the totals in the spreadsheet including the grand
total and the +- bar on the left?

Thanks


--

Dave Peterson