I assume your headers are in Row 1, so yes, you'd make row 2 your blank row,
that is, blank until you type "AAA" into each sort key (or each cell). The
"AAA" will ensure that the row always stays at the top if you are sorting
alpha data. I should have made the point if you are sorting numerical data
that you should instead of "AAA" use a numerical value that will be much
larger (for descending sort) or smaller (for ascending sort) than anything
you would be likely to be sorting. If you need to sum the columns, be sure to
cancel those two rows out by contra-ing the positive value with the same
negative value, thus eliminating the need to deduct the "dummy" values in the
Sum formulae.

EG: Column A
Row 1 Header
Row 2 999,999,999 (narrrow & shaded)
Row 3-99 all your data
Row 100 -999,999,999 (narrrow & shaded)
Row 101 "=sum(A2:A100)

Range Name, say, A2-Z100 = "SortArea"

Save a copy of the file before you run the sort ;-)

By the way, its not a bad idea, if you have any formulae that rely on
testing for a zero value to limit the decimal places with a function such as
"Round". Spreadsheets do funny things after about a zillion decimal places,
but its enough to through a zero test off.

Cheers






"PY & Associates" wrote:

On Mar 11, 10:26 am, CC wrote:
I have an excel document with 35000 rows and 125 columns of information. I
am sorting in almost every title column in multiple formats. is there a way
to sort these with out always having to notify the sort I have headers?

I want to click AtoZ or ZtoA and just go with out taking all the extra steps
to manage the headers.

Can you insert blank row in row2 please?
.