View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Crosscom
 
Posts: n/a
Default How to sort in excell

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.