pprotect column headings while sorting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I don't know how it happened, but after I modified an existing database, every time I try to sort by rows, the column labels get sorted too. Then I can't do a mail merge in Word, among other problems. I tried blocking the whole label row and "freeze panes" but it didn't do anything. I think I am in Excel 2000.
 
When you the sort window comes up, make sure the "header
row" radio button is checked.

-----Original Message-----
I don't know how it happened, but after I modified an
Click to expand...
existing database, every time I try to sort by rows, the
column labels get sorted too. Then I can't do a mail
merge in Word, among other problems. I tried blocking the
whole label row and "freeze panes" but it didn't do
anything. I think I am in Excel 2000.
 
Rose

Select all the columns you want in your data range.

Then Data>Sort. Place a Checkmark in "My list has" "Header Row" then sort by
one or more of your selected columns.

All selected columns will sort together and header row will stay where it is.

Gord Dibben Excel MVP
 
Back
Top