One way to do this is to use a named range which would have everything other
than the first three rows. Then When you want to sort, Just select the
named range.

"Suzy Greblo" wrote:

I have three rows at the top of my Excel spreadsheet. One row is the column
names; the other two rows contain data used in formulae elsewhere in the
spreadsheet. Is there any way to do it without first selecting the data? I've
found this method is very prone to error.

How do I sort the data without sorting in the three header rows? Designating
"header row" in the sort dialogue only identifies one row.