Topics Map > IT Services > Training
Topics Map > IT Services > Software Support

Microsoft Excel 2016 - Sorting Data

This guide will show you the basics of sorting data in Excel.

Sorting data can be done in Excel for simple tasks like sorting by one column, or more intensive things such as sorting by 3 columns.


Custom Sorting

  1. Select all the data which should be sorted by left-clicking and dragging over the cells. 
    • Do not select the header row.
  2. On PC, select the Home tab. Then select the Sort tool. On Mac, simply select the Sort tool from the toolbar. 
  3. From the Sort Tool Drop Down Menu, select Custom Sort.
  4. Choose the desired sorting method.
    • To add multiple sorting methods, select the + arrow in the bottom left corner of the Sort Window.
    • These options can then be arranged in whatever order is desired.

Quick Sorting

Sometimes an in-depth custom sort is not necessary. If a spreadsheet only needs to be sorted by one column, then quick sorting can save a little time.
  1. Select the row which should be the determining factor in sorting.
  2. Select the Sort Tool from the toolbar.
  3. Select either Ascending or Descending from the pop-up menu.
  4. Select Expand the Selection, then select Sort.

If you need further assistance please contact the Information Technology Help Desk at 920-424-3020 or

Keywords:quick, custom, "Data Management"   Doc ID:65967
Owner:Richard L.Group:UW Oshkosh
Created:2016-08-10 15:19 CDTUpdated:2016-08-10 15:20 CDT
Sites:UW Oshkosh
Feedback:  0   0