Data -> Sort & Filter ->Sort

Data: Sort Order

There is another kind of Sort that can be found on the Data Ribbon. This Sort lets you use one or several criteria. The criteria comes from the names in the Header Row.

 

5. Try it: Data Sort

Select the whole spreadsheet.

Go to Data -> Sort & Filter ->Sort.

What Do You See? The options include:

Add Level

Delete Level

Copy Level

There should be a check mark for:

My data has Headers.


Try This, Too: Edit the Sort Options

Sort by: Month

Sort On: Values

Order: Custom List (Remember, A to Z didn't work for Months. Keep going...)

Exam 77-882: Microsoft Excel 2010 Core

8. Analyzing and Organizing Data

8.2. Sort data: Sort data using single or multiple criteria 

 

 

 

  .