sorting data

[Rob K]

Hi

I have a sheet of phone numbers etc, how do I sort them automatically. all the time I have done it before, I just highlight the column, click on the AZ on the ribbon and a box pops up asking to expand the range. On this computer I am using, it seems that something has happened as it is only sorting the single column.

To clarify, I have columns A to E and I want all sorted with column C being the one that is in alphabetical order.

Any help on this would be much appreciated.

Kind regards
Rob

[Pepe Le Mokko]

Do your columns have headers?

[Rob K]

No they don't

[Teblol]

What happens if you go to Data > Sort > Sort by column C instead of just clicking on AZ?

[vibert_c]

Rather than highlighting only column C, I have to highlight all the data I want to move in the sort operation. Then sort by column C. It works for me with Excel 2000.

[Pepe Le Mokko]

Could you please post a small sample file?

[vibert_c]

To clarify, I have columns A to E and I want all sorted with column C being the one that is in alphabetical order.
You must highlight your entire A to E data before commencing to execute your sort command. If you fail to do this, Excel will only sort the individual column C. The computer can't think, it only follows commands.