BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Some tasks in Excel always seem to take longer than they should - if only you knew a bunch of quick shortcuts to speed up the simple things. Read on to see how much time you could save!
- Excel Quick Tip #1 - Copying a Formula
- Excel Quick Tip #2 - Putting Dollar Signs in a Formula
- Excel Quick Tip #3 - Adding Totals to Columns
- Excel Quick Tip #4 - Selecting a Table
- Excel Quick Tip #5 - Sorting a List (this blog)
- Excel Quick Tip #6 - Creating Range Names
- Excel Quick Tip #7 - Creating a Chart
- Excel Quick Tip #8 - Copying a Worksheet
- Excel Quick Tip #9 - Entering Today's Date
- Excel Quick Tip #10 - Copying Days and Months
Posted by Andrew Gould on 02 December 2011
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Excel Quick Tip #5 - Sorting a List
There are only two things that you need to do in order to sort a list in Excel:
- Click on a single cell in the column you want to sort the whole table by.

Here we want to sort the entire list alphabetically by name, so we select a single cell in the movie name column.
- Choose to sort the list in either ascending or descending order.

Here we're choosing to sort in ascending order.
Even though you only have a single cell selected, Excel is clever enough to work out to sort the entire list.

The whole list has been sorted, even though only a single cell was selected.
You can watch this technique in action in this short video.
- Excel Quick Tip #1 - Copying a Formula
- Excel Quick Tip #2 - Putting Dollar Signs in a Formula
- Excel Quick Tip #3 - Adding Totals to Columns
- Excel Quick Tip #4 - Selecting a Table
- Excel Quick Tip #5 - Sorting a List (this blog)
- Excel Quick Tip #6 - Creating Range Names
- Excel Quick Tip #7 - Creating a Chart
- Excel Quick Tip #8 - Copying a Worksheet
- Excel Quick Tip #9 - Entering Today's Date
- Excel Quick Tip #10 - Copying Days and Months