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?

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?

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?

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

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?