ExcelBanter - sorting header

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sorting header (https://www.excelbanter.com/excel-discussion-misc-queries/222081-sorting-header.html)

Lani Ziller

sorting header

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

Sheeloo[_3_]

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?

All times are GMT +1. The time now is 07:00 PM.