Sorting Data by Multiple Columns in Excel

1. Click into the column you wish to sort

2. Click either Sort Ascending or Sort Descending.  In Excel 2003 these buttons are found on the Standard toolbar.  In Excel 2007/10 these buttons can be placed and used on the Quick Access Toolbar

Sorting by Multiple Columns

1. Sort by column as described above.

2. The order that you sort is important:  the first column you sort by will be sorted within the second.  The second within the third and so on.

Freezing Panes in Excel

To freeze columns and/or rows so they stay on screen when you scroll, click in a cell that is beneath the rows you want to freeze and/or to the right of the columns you want to freeze.

Excel 2003 users

Click Window | Freeze Panes

Excel 2007/2010 users

Click View [tab] |Freeze Panes |Freeze Panes

NB. Go back to the same commands to unfreeze panes.