View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Firemann59 Firemann59 is offline
external usenet poster
 
Posts: 3
Default I want to use subtotals in Excel and hide all rows except total

In Excel, I am filtering data and then using subtotals. I then need to hide
all rows except the total rows and keep the totals intact. Is there a way to
do this?