Excel Data AnalysisLesson 29Free preview

Excel Sort

This lesson is part of Excel · All levels

Summary

Sort rearranges the data line based on the value of a column, from small to large (A to Z) or vice versa. Custom Sort allows sequencing with multiple criteria at once and even based on colors or icons. When sorting the columns in the middle of the table, always use Expand the selection to keep the column-to-column relationship intact.

Key points

A to Z is ordering up, Z to A is ordering down.
Expand the selection to keep the entire line intact when sorted
Custom Sort supports a number of criteria and color-based ordering
Select Data > Sort for the full order dialog

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.