ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to sort when I have multiple header rows (not included in sor. (https://www.excelbanter.com/excel-discussion-misc-queries/257264-how-sort-when-i-have-multiple-header-rows-not-included-sor.html)

K_Millan

How to sort when I have multiple header rows (not included in sor.
 
I have a spreadsheet with three rows of "header" information (Section title,
Column title, Column total). How do I sort (A to Z) without including the top
3 rows in the sort? Thanks!

Dave Peterson

How to sort when I have multiple header rows (not included in sor.
 
Select your range to sort first--don't include the headers.

Then use Data|sort and specify that the selection doesn't include headers.

K_Millan wrote:

I have a spreadsheet with three rows of "header" information (Section title,
Column title, Column total). How do I sort (A to Z) without including the top
3 rows in the sort? Thanks!


--

Dave Peterson


All times are GMT +1. The time now is 12:09 PM.

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