GCFLearnFree.org

I love your videos. Everything is so precise and to the point.”

Online Learner

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

Excel 2013

Single page view print copy

Sorting Data

Challenge!

  1. Open an existing Excel workbook. If you want, you can use the Lesson 18 Practice Workbook.
  2. Sort a worksheet in ascending sort ascending or descending sort descending order. If you are using the example, sort by Homeroom # (column A).
  3. Sort a cell range. If you are using the example, sort the cell range in the cell range G3:H7 from highest to lowest by Orders (column H).
  4. Add a level to the sort, and sort it by cell color, font color, or cell icon. If you are using the example, add a second level to sort by cell color in column E.
  5. Add another level, and sort it using a custom list. If you are using the example, create a custom list to sort by T-Shirt Size (column D) in the order of Small, Medium, Large, and X-Large.
  6. Change the sorting priority. If you are using the example, reorder the list to sort by T-Shirt Size (column D), Homeroom # (column A), and Last Name (column C).
previous next
previous 1 2 3 4 next
Terms Of Use

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