protect 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.
 
Did you do Data|sort?

If yes, there's an option that you can check that says "My List has" "header
row" or "no header row".

If you're using the icons on the toolbar, I'd stop. (sometimes they don't sort
the whole range I want sorted--if I'm not careful with my selection.)

Excel will guess at the head row option button. But if you format the header
row (bold???), xl will guess correctly more often.
 
Back
Top