Suggestion - Here's my trick: Name the range you want to sort, excluding the
titles. Record a macro and create a macro button to perform the sort for you.
I'm on Excel 2000 still, so if I tell you the exact steps I use it probably
will be different for you.

Now be careful - there's a potential problem: Adding rows at the top or
bottom later on will likely result in those rows being outside the named
range and being omitted from the sort. To prevent that happening, you can
insert a blank row at the top and bottom of the range, reduce their height to
very narrow and shade them with (say) grey (be sure to INCLUDE the shaded
rows in the range when derfining the range name). You'll then always know to
add any more rows BETEEN the shaded rows. Those shaded rows will never be
used for your data, but by entering "AAA" or "ZZZ" in each cell - or just the
sort keys - in those rows (and formatting their text colour to the same as
the shading so its tidy and not visible) the shaded row will always sort to
the beginning or end of your sort.

Let me know if you need any more explanation,
Cheers

"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.