Excel 2000 problems

[vidon]

One more newbie question...

One of my departments uses a shared Excel spreadsheet that they all update. I originally created it in Excel 97, and had no difficulty "freezing" the top row of the spreadsheet, so that they could alphabetise entries in the other rows without dislodging the header information in the first row.

Since converting to Excel 2000, I seem no longer to be able to freeze the top row. (I've tried locking cells -- doesn't work.) Any time someone alphabetises, it will throw the top row into alphabetical order...

For the moment, I've worked around this by adding spaces before each heading -- not exactly the high-tech solution... ;-)

Also, I've occasionally experienced a problem where, when someone alphabetises based on the contents of one column, *only* that column alphabetises -- throwing all the data in the other columns out of synch... I'm not sure what causes this to happen -- or why it doesn't *always* happen...

Thanks for your help...

 

[JVFriederick]

Try walking through the data sort process "manually", and watching the range and parameters that Excel considers.

Often, Excel will remember how it was last sorted, and carry on from there. Someone may have excluded/included headers in the last sort prior to saving the file.

Your data may have changed, and now includes blank cells that Excel doesn't include in the "artificial intelligence" sort.

A simple macro/button may help to avoid the problem of someone manually changing sort parameters.

I'm just guessing, so if I really missed the mark - sorry !

 

[MSUser]

Make sure that when you select data for sorting that you check the box that indicates there is a header row; otherwise it will include the header in the sort. Select Data, Sort , etc.