﻿ How to Use Sort and Auto Sort in MS Excel 2007
MS Office Training
 Excel Tutorial Excel Formulas Microsoft Word Training

Typing Training
 Typing Games For Kids Typing Tutorial Typing Test

Math Games
 Math Games Place Value Probability

Spelling & Vocabulary
 Spelling Games Crossword Puzzles Word Search

Grammar & Writing
 Learn English Grammar Creative Writing Course

Life Skills for Kids
 Good Study Habits Goal Setting Financial Literacy

Relaxing Mindfulness

Website Info
 Excel Basics Formulas & Functions Special Features Format Cells Sum, Average, Countif Functions Excel Charts (Graphs) Worksheets Quick Functions Excel Sort Edit Cells The IF Statement Excel Filter Rows and Columns VLOOKUP Function Conditional Formatting Find and Replace Sumif Function Pivot Table The Fill Handle Excel Formulas Create a Drop Down List Excel Keyboard Shortcuts First Aid

# Sorting Data in Excel

Here are tutorial videos teaching how to sort in Excel. With only a few clicks you can choose to sort your data alphabetically in ascending (A to Z) or descending (Z to A) order, or by numerical value. See how you can arrange your data into groups, by sorting by more than one criteria. All with easy examples and by self practice spreadsheets.
Simple sorting
Sorting by more than one criteria
More sorting examples
When should you use Excel's “Sort”?

Whenever you wish to rearrange the rows of a table in a useful and practical order.

For example: arranging a table of students by their last names in alphabetical order, or arranging a list of bank accounts by the account number.

You can also arrange by two or more criteria:
For example, Let’s assume you are a high school principal, and you have a list of all your pupils.
You might want to arrange your list and organize it by three categories:
First, by the different grades (in ascending order, from lower to higher), then within every grade by the different classes, and then within every class, by the pupil’s last name in alphabetical order.

Excel XP and 2003 allows you to sort by up to 3 different criteria, but from Excel 2007 it has been extended to up to 64 different criteria! But only on rare occasions you will need to use more than three. The need does arise when dealing with databases of thousands of records.