10 Excel Quick Tips
Part five of a -part series of blogs

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!

  1. Excel Quick Tip #1 - Copying a Formula
  2. Excel Quick Tip #2 - Putting Dollar Signs in a Formula
  3. Excel Quick Tip #3 - Adding Totals to Columns
  4. Excel Quick Tip #4 - Selecting a Table
  5. Excel Quick Tip #5 - Sorting a List (this blog)
  6. Excel Quick Tip #6 - Creating Range Names
  7. Excel Quick Tip #7 - Creating a Chart
  8. Excel Quick Tip #8 - Copying a Worksheet
  9. Excel Quick Tip #9 - Entering Today's Date
  10. 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:

  1. Click on a single cell in the column you want to sort the whole table by.
Select a single cell

Here we want to sort the entire list alphabetically by name, so we select a single cell in the movie name column.

  1. Choose to sort the list in either ascending or descending order.
Choosing to sort

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.

Sorted 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.

  1. Excel Quick Tip #1 - Copying a Formula
  2. Excel Quick Tip #2 - Putting Dollar Signs in a Formula
  3. Excel Quick Tip #3 - Adding Totals to Columns
  4. Excel Quick Tip #4 - Selecting a Table
  5. Excel Quick Tip #5 - Sorting a List (this blog)
  6. Excel Quick Tip #6 - Creating Range Names
  7. Excel Quick Tip #7 - Creating a Chart
  8. Excel Quick Tip #8 - Copying a Worksheet
  9. Excel Quick Tip #9 - Entering Today's Date
  10. Excel Quick Tip #10 - Copying Days and Months
This blog has 0 threads Add post