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.

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, DataSortMy 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
wrote:

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.

1. Select the entire range of cells that you want to sort, excluding the header row. You can do this by clicking on the first cell of the data range and dragging down to the last cell.
2. Click on the "Data" tab in the ribbon at the top of the Excel window.
3. Click on the "Sort" button in the "Sort & Filter" section of the ribbon.
4. In the "Sort" dialog box, select the column that you want to sort by from the "Sort by" drop-down list.
5. Choose the sort order (ascending or descending) from the "Order" drop-down list.
6. Click on the "Options" button in the "Sort" dialog box.
7. In the "Options" dialog box, make sure that the "My data has headers" checkbox is checked.
8. Click on the "OK" button to close the "Options" dialog box.
9. Click on the "OK" button in the "Sort" dialog box to apply the sort.

This should sort your data without moving or touching the top row where the column header information is.

Here's how you can sort a worksheet without including the column header row:

1. Select the entire range of cells that you want to sort, but exclude the first row that contains the column headers.
2. Click on the "Data" tab in the ribbon at the top of the Excel window.
3. Click on the "Sort" button in the "Sort & Filter" group.
4. In the "Sort" dialog box that appears, make sure that the "My data has headers" checkbox is checked.
5. In the "Sort by" dropdown menu, select the column that you want to sort by.
6. In the "Sort On" dropdown menu, select "Values".
7. In the "Order" dropdown menu, select either "Smallest to Largest" or "Largest to Smallest", depending on how you want to sort the data.
8. Click on the "Add Level" button if you want to sort by multiple columns.
9. Repeat steps 5-7 for each additional column that you want to sort by.
10. Click on the "OK" button to apply the sort.

This should sort your data without moving or touching the top row where the column header information is. Let me know if you have any other questions!