You have a mega spreadsheet. Loads and loads of data. It has taken you ages to compile it for your client. As you finish, panic sets in. Adding the data was easy. What if the client asks you to provide it sorted in a particular way?
What is the fastest way to sort your Excel data?
When I teach this in the classroom, I always ask the question – how do you sort your data? I usually get a few different answers.
- Select the whole spreadsheet then click the Data Ribbon and the big Sort Button
- Select the column to sort by and click Click A/Z or Z/A sort on the Data Ribbon
- Click the Sort and Filter button on the Home Ribbon
Then I get someone say, but it never sorts everything. My data is all over the show.
So let’s debunk some sorting myths.
The absolutely fastest and most accurate way to sort a whole spreadsheet by the values in one column is to:
- Click into the column
- Click on the A/Z sort icon (it is on the Data Ribbon the right click or the drop down on the Home Ribbon)
Hey Presto! Your whole worksheet is sorted and it keeps everything together.
So to recap:
- Click into the column to sort by
- Click on the sort icon you like to use.
Did this help? Have you learned something new? How will you use it? Leave a comment below.
P.S – have you joined my Facebook Group yet? Join in and ask questions, get answers and generally interact. See you there