Skip to content
Back to template gallery
Google Sheets
Google Sheets

How to sort alphabetically in Google Sheets

A ready-made, step-by-step walkthrough. Preview every step below — then make it your own in seconds.

Operations
4 steps 2 min Community template
Use this template Add Haiku to Chrome
1

This Haiku shows you how to sort a column of data alphabetically. You can do so from A to Z or Z to A (note - this also applies to numbers and will sort from smallest to largest or largest to smallest, respectively)

This Haiku shows you how to sort a column of data alphabetically. You can do so from A to Z or Z to A (note - this also applies to numbers and will sort from smallest to largest or largest to smallest, respectively)

2

Make sure you have added a filter to your data set.

Make sure you have added a filter to your data set.

docs.google.com/spreadsheets
Make sure you have added a filter to your data set.
3

Click the filter icon in the appropriate column header to open up the filter option

Click the filter icon in the appropriate column header to open up the filter option

docs.google.com/spreadsheets
Click the filter icon in the appropriate column header to open up the filter option
4

Click "Sort Z → A"

Click "Sort Z → A"

docs.google.com/spreadsheets
Click "Sort Z → A"

Make this walkthrough your own

Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.

Use this template Add Haiku to Chrome