Sort a List Alphabetically

Sort rows A to Z while keeping each row together.

You will learn to

• Sort A→Z by a column
• Keep rows intact with a header row

How it works

Select any cell in your list and choose Data → Sort A to Z. Excel detects headers and keeps each row together. To sort by a different column, use Data → Sort and choose the column.