Keep rows together when hidden

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hi I am sure there is a way of keeping rows together when sorting but
can not remember how to do it.

ie 2 rows are totalled in a 3rd row, and the 2 rows are hidden, when a
sort is done they all get sorted together, thanks
 
If you've created the subtotals via data|subtotal, you could hide the details
(using the outlining symbols on the left) and then sort by the subtotal/visible
rows. The details/hidden will sort with them.
 
Back
Top