Exclude Row in Sort

P

Pablo

I have some data with headers and a subtotal row. Row 1 is the
headers, row 2 is the subtotal and row 3 on is the data. I can sort
the data without losing the subtotal if I put the subtotal above the
headers, but I don't like that layout.

Is there a way to exclude the subtotal row from the sort?
 
R

Ron Rosenfeld

I have some data with headers and a subtotal row. Row 1 is the
headers, row 2 is the subtotal and row 3 on is the data. I can sort
the data without losing the subtotal if I put the subtotal above the
headers, but I don't like that layout.

Is there a way to exclude the subtotal row from the sort?
Click to expand...

Select just the data, and then indicate "no headers" in the dialog box before sorting.

In other words, if your table is in A1:E500, select A3:E500
 
Top