Thread: sorting header
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default sorting header

No direct way.

You can add a dummy column and enter 0,1,2... for the rows you want to
retain at the top and 99 (something greater than the no. of rows you want to
keep) for others and keep that at the highest sort level.

"Lani Ziller" wrote:

Is there a way to designate more than one row as a header when sorting?