Hi
You could insert a blank, hidden row underneath row 2. This would make Excel
assume that the extent of your data is row 4 downwards. When you sort,
however, you will have to use column names (A, B etc) rather than what is in
the top row. Some people posting on this site always advocate manually
selecting data for sorting anyway. Then Excel can't guess and get it wrong!

--
Andy.


"Toney" wrote in message
...
Hi all,

Is there a way to automatically exclude the top two rows from a sort? I
realize we could simple highlight the other rows but this file has alot of
columns and it's kind of a pain to make sure we have the everything but
the
top two rows selected.

Thanks

Toney