Sorting error?

  • Thread starter Thread starter NikkoW
  • Start date Start date
N

NikkoW

I'm hoping someone can help me with a problem I am having with Excel 2000.

I have several columns of data with a header row and want to alpha sort all
the data according to the names in column C.

I click in column c and click on the sort button. My header row gets sorted
along with everything else. If I use the Data>Sort dialog I don't have this
problem. This used to work until recently.

BTW, I have the header row separated from the rest by a Freeze Pane. There
is no empty row under the header.

Any idea what gives???

Nick
 
Hi
Excel 'guesses' the structure of your data and maybe gets confused by
freezed panes. So easiest solution is to use the menu
 
Does your header row have any special formatting, like bold face or bottom
borders? If not, try applying something like that. In looking for a header
row, Excel also looks for a top row that's formatted differently than the data
below it.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

writing a sort macro 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Sorting issue with frozen panes 11
Sort confusion 2
stop sorting titles please 3
How to sort when I have multiple header rows (not included in sor. 1
Sorting a Selection 2
Excel "remembering" sort criteria 3

Back
Top