Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sorting
I have a spreadsheet with Row 1 and Row 2 as headers. When I sort, it sorts
the 2nd row header with my information. Is there a way to keep row 2 from sorting with my infor? |
#2
|
|||
|
|||
Hi,
Why do you have two rows? I recommend concatenating the two into one row only - insert a new row and in A1: =A2&" "&A3 Copy this formula throughout the length. You can still wrap the text within the cell. You can then copy row 1 and paste over it again as values (Edit - Paste Special). Delete rows 2&3 and re-sort. Regards, A "Pam Coleman" wrote: I have a spreadsheet with Row 1 and Row 2 as headers. When I sort, it sorts the 2nd row header with my information. Is there a way to keep row 2 from sorting with my infor? |
#3
|
|||
|
|||
Pam,
Instead of having Excel guess what range to sort, simply select from row 2 to the end of your data table, then do the sort. Make sure that you indicate that you have a header row, and Excel will leave row 2 at the top. HTH, Bernie MS Excel MVP "Pam Coleman" wrote in message ... I have a spreadsheet with Row 1 and Row 2 as headers. When I sort, it sorts the 2nd row header with my information. Is there a way to keep row 2 from sorting with my infor? |
#4
|
|||
|
|||
Don't select header row 1--just select the last row of the header and the data.
Or just select your data and make sure you choose no header row on that sort dialog. (And don't use those A-Z and Z-A buttons. Go through the menu (data|sort). You'll have much more control. === ps. You may want to combine your all your header rows into one row. You can use alt-enter to force a new line within a cell. Pam Coleman wrote: I have a spreadsheet with Row 1 and Row 2 as headers. When I sort, it sorts the 2nd row header with my information. Is there a way to keep row 2 from sorting with my infor? -- Dave Peterson |
#5
|
|||
|
|||
Insert a blank row between Rows 1 & 2. Then hide the row.
-Scott "Pam Coleman" wrote: I have a spreadsheet with Row 1 and Row 2 as headers. When I sort, it sorts the 2nd row header with my information. Is there a way to keep row 2 from sorting with my infor? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . . | Excel Discussion (Misc queries) | |||
sorting number in ascending order | Excel Discussion (Misc queries) | |||
SORTING question | New Users to Excel | |||
Adding a KeyID column for sorting | New Users to Excel |