sorting header

  • Thread starter Thread starter Lani Ziller
  • Start date Start date
L

Lani Ziller

Is there a way to designate more than one row as a header when sorting?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

writing a sort macro 2
Sorting issue with frozen panes 11
SORT Header Row(s) 1
stop sorting titles please 3
Sort confusion 2
Excel "remembering" sort criteria 3
Sort Default 1
Header rows 4

Back
Top