How do I sort a worksheet without including the column header row

[Navy Neophyte]

I have a worksheet that is over 4000 cells down and 18 cells wide. I often
need to to do sorts on the different columns. When I do a sort, the first ROW
is sorted along with the rest of the worksheet and ends up somewhere in the
worksheet.

What I want to do is do a sort WITHOUT moving or touching the top ROW where
the column header information is. I have tried freezing and that does not
work, any help will be appreciated.

 

[Gord Dibben]

If your first row.........titles I presume is formatted to Bold or different
from the other rows, Excel will generally take that as a header row and not
sort.

Failing that, Data>Sort>My data range has a header row should be checked.

With the formatting of my header row, Excel always gets it right.


Gord Dibben MS Excel MVP

On Thu, 31 May 2007 11:03:03 -0700, Navy Neophyte <Navy