I have a brand new excel 2003 file and have the following numbers in cells
A1:A10.
10
6
4
5
3
1
8
7
2
9
now, if I click the sort buttons on the toolbar the column sorts
correctly in either direction.

Now, make three random cell have a background color and then try and sort.
My column no longer sorts correctly in either direction. If I remove the
background colors from the cells they will sort correctly again.
I have looked at the header row (under data:sort) and it is set to "no
header row".
How do I get around this problem?

Thanks