Have a large excell file and when trying to sort the entire file w/o the
heading rows, an error comes up "this operation requires the merged cells to
be the same size". I know I can select the table less the heading rows, but
this requires an addition step and time.

Is there a way to sort, eliminating the first two rows in the sort, w/o
having to highlight the rest of the table after the headings? I've added the
first two rows to freeze to keep them on top, but this doesn't help in the
sorting.

Try creating a named range by selecting the area you want to sort, then
selecting Insert|Name|Define... and typing in the name you wish (e.g.,
I use "SortRange").

Then type "SortRange" into the name box (to the left of the formula
bar) - or just select - and you'll have your range selected and ready
to sort.

Thanks that works.

"Mark Lincoln" wrote:

Try creating a named range by selecting the area you want to sort, then
selecting Insert|Name|Define... and typing in the name you wish (e.g.,
I use "SortRange").

Then type "SortRange" into the name box (to the left of the formula
bar) - or just select - and you'll have your range selected and ready
to sort.