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 course and covers where the sorting option is found and how to use it.Excel environment: Excel icon 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?

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy