Excel Sorting – how do I sort my data in Excel? Watch the video to learn more
This week’s hint and tip is about how to use the sorting option within Excel. This is on our Intermediate Excel training course and covers where the sorting option is found and how to use it. We are going to go through it now below.
Where the sorting option is found
There are three ways to find the sorting option in Excel. The first is to go to the Data Tab. From here you can use the A-Z filter buttons or click on the sort button. The second is go to the Home Tab and click on the sort and filter button. When you click on this button, the sorting options can be found on the drop down list. Finally the third option is to add the A-Z and Z-A shortcut buttons to your QAT.
How to sort your data
To sort your data, you only have to select one active cell in the column you want sorted. To sort a column, select one cell and then select the A-Z button. This will sort your data in alphabetical order by the column you selected the cell in. This is a simple single level sort. You can also apply multi level sorting to your data. To do this, click on the fort button on the Data Tab. This will bring up a box where you can select the details for your first level of sorting. Once this is done, click on the add level button and this will allow you add the second level to your sorting. Same as before, select the details for the second level of sorting then click OK. This will then sort your data first by the first level details then by the second level details.
The video below shows you how to sort your data in Excel. Sorting is very powerful in Excel and is useful for ordering your data to make it easier to read.
Take a look below at the video to find out more and then try it out on your own computer!
We hope you have enjoyed this hint and tip, why not take a look at our previous one on replicating spreadsheets?