For training call +44(0)1273 622272

Your basket is empty View Cart shopping cart

theBLOG

Working With Lists in Excel Step By Step (With Pictures)

Written by Andy Trainer – Thu 29 Jan 2015

Use these step by step instructions to sort your lists with maximum efficiency in Excel.

Sorting Lists

Excel can sort columns into order alphabetically and numerically. You can perform a single column sort of multi column sort.

The Sort command can be found on the Home tab under the Editing group.

Important: When setting up the list, include a set of column headings (as example below). These are used to control the sort columns. The list must be sequential, i.e. no row gaps from the top of the list to bottom.

Single Column Sort

Click into a cell in the column that you wish to sort by, as in the example below the First Name column.

Select the Data tab, then to sort by A to Z or Z to A.

Read More