Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hello, and welcome to JustAnswer!
So, you want to sort the first column from A->Z but want to make sure the data in the other columns is arranged accordingly, right?
So, press CTRL+A to select all columns, then right click and select Sort->A->Z
Make sure you do this with all cells selected.
Don't worry. If you think the result is not OK, you can revert by pressing CTRL+Z keys.
Thanks! I'll try it now
Let me know if there is any problem. Otherwise you can click accept.
it didn't do anything
i.e. when you clicked, Sort A-Z?
right, CTRL +A selected all columns but when I clicked Sort A-Z it didn't do anything
Select only the data portion with your mouse and try Sort->A->Z option.
Sorry. Here is more convenient way of doing it.
Select a cell in the column you want to sort.
Then right click on it and do the sort.
This is very handy
That worked perfectly! Thanks so much