Forum Discussion
BernardThomasWalsh
Apr 01, 2020Copper Contributor
Sorting in Excel
Hi All, I'm new to this so just throwng looking for advice. If i have a table i want to sort via clicing on watver cell i click, how do i do this? For example if my table was as below i want ti ...
Abiola1
Apr 01, 2020MVP
To sort in Excel is one of the simplest operation.
All you need to do is to right-click on the column you want to sort. Then select Sort A - Z or Sort Z - A.
To Sort on Multiple columns, click on the Custom Sort in the data tab. Select the columns from the dropdowns
All you need to do is to right-click on the column you want to sort. Then select Sort A - Z or Sort Z - A.
To Sort on Multiple columns, click on the Custom Sort in the data tab. Select the columns from the dropdowns
- BernardThomasWalshApr 01, 2020Copper ContributorHi there. I know that. I'm trying to find out low you get 2 arrows both up and down in the cells thus whatever cell you click on the table automatically sorts by that columb?
Like the one attached. Thank you for replying! 👍👍- mathetesApr 01, 2020Silver Contributor
Do you have reason to believe that's an Excel screen shot?
It might be, I suppose, but I've never seen that pairing of arrows in the headings of an Excel Table...
If it is, and you do find out how to do it , please come back and share the news.