ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Header Rows and Sort Issue (https://www.excelbanter.com/excel-discussion-misc-queries/79899-header-rows-sort-issue.html)

MikeL.

Header Rows and Sort Issue
 
When sorting via the quick sort the header row is moving, when you do sort
and choose header row it work, but the information on header row then goes
away and the quick sort moves the header row. Any way to make the header
stay put?

Dave Peterson

Header Rows and Sort Issue
 
Excel likes to guess whether your list includes a header.

If you make it easier by bolding the header (or some other formatting change),
excel may guess correctly.

MikeL. wrote:

When sorting via the quick sort the header row is moving, when you do sort
and choose header row it work, but the information on header row then goes
away and the quick sort moves the header row. Any way to make the header
stay put?


--

Dave Peterson


All times are GMT +1. The time now is 06:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com