GCFLearnFree.org

This has really aided my job search and created ample opportunities.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2010
  • Sorting Data

Excel 2010

Single page view print copy

Sorting Data

Challenge!

  1. Open an existing Excel workbook. If you want, you can use this example.
  2. Sort a column in ascending sort ascending or descending sort descending order. If you are using the example, sort by Homeroom #.
  3. Add a second level, and sort it according to cell color, font color, or cell icon. If you are using the example, add a second and third level to sort by the red and grey fonts used in T-Shirt Color.
  4. Add another level, and sort it using a Custom List. If you are using the example, sort by T-Shirt Size in the order of Small, Medium, Large, and X-Large.
  5. Change the sorting priority. If you are using the example, re-order the list to sort by T-Shirt Color (red), then by T-Shirt Color (grey), then by T-Shirt Size, then by Homeroom #.
previous next
previous 1 2 3 4 5 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.