Sorting

[Richard]

I want to sort from cell a1 to a10 by selecting them and choose sort
ascending. However, only the cell a2-a10 are sorted, and cell a1 is leaving
out every time I do this. Is there is bug in my excel or something?

 

[Guest]

You have " header row" selected.
Do this:

Data> Sort > select "No header row"

 

[Pete_UK]

Excel is assuming that you have a header row (which obviously does not
get sorted). Select A1:A10, click on Data | Sort, then in the dialogue
box click on No Header Row.

Hope this helps.

Pete