How to Sort in Google Sheets and Alphabetize Data

A messy spreadsheet is one of the quietest time-wasters in a small business. A customer list in the order you typed it, product names jumbled, dates all over the place: you can't spot anything until you tidy it. Sorting is the fix, and Google Sheets gives you more than one way to do it.

The same steps cover people searching for how to alphabetize in Google Sheets, because alphabetical order is simply sorting A to Z. I've followed Google's own help below, including the bits that stop sorting from going wrong.

Sorting a whole Google Sheets tab from A to Z or Z to A

This is the quickest way to alphabetize a column and keep every row together. According to Google's help:

1. Open your spreadsheet.
2. Right-click the column letter at the top of the column you want to sort by.
3. Click Sort sheet A to Z, or Sort sheet Z to A.

Because it sorts the entire sheet, each row stays intact. A customer's name, email and notes all move together instead of your names being shuffled away from their details. That's the mistake most people make with sorting, and this route avoids it.

Sorting only part of a Google Sheets table by one or more columns

If your sheet holds several tables, or you only want one block in order, sort a range instead. Google's steps are:

1. Highlight the cells you want to sort.
2. If the sheet has a header row, freeze the first row.
3. Click Data, then Sort range, then Advanced range sorting options.
4. Tick Data has header row if your columns have titles.
5. Choose the column to sort by first, and the sort order.
6. To sort by a second column as well, click Add another sort column.
7. Click Sort.

The second sort column is handy for things like sorting a client list by country and then by surname. Google's help puts it simply: you can sort data in alphabetical and numerical order, or use filters to hide data you don't want to find.

Why ticking the header row box matters in Google Sheets sorting

If you don't tell Sheets that row one holds titles, it treats the titles like any other data and sorts them into the list. Ticking Data has header row keeps your column names at the top. Freezing the first row, as Google recommends, also keeps them visible while you scroll.

When a sort goes wrong, use Undo in the Edit menu straight away, then check the header box and your selection. That's usually the culprit.

Sorting a Google Sheets column by colour

Using colour codes is common in team spreadsheets: red for urgent, green for done. Google lets you sort by it:

1. Select a range of cells.
2. Click Data, then Create a filter.
3. Click the Filter icon at the top of the range.
4. Under Sort by color, choose the text colour or fill colour to sort by.

Google says cells with the colour you pick move to the top of the range. You can sort by conditional formatting colours, but not by alternating colours.

Using a filter view to sort Google Sheets without bothering your team

Here's a catch that matters in shared spreadsheets. Google's help says that when you add a filter, anyone with access to your spreadsheet will find the filter too. If you share a sheet with colleagues or clients, your sorting can change what they see.

A filter view is the answer. Google describes it as filter settings that only you use. Click Data, then Create filter view, sort and filter as you like, then save the view. Other people carry on looking at the sheet as it was.

Sorting or filtering in Google Sheets: which should you use

What you want	Best option
Put everything in alphabetical order	Sort sheet A to Z
Order just one block of data	Sort range
Hide rows you don't need right now	Filter
Look at the data your way without changing it for others	Filter view
Bring red or green cells to the top	Sort by color

If you're building a spreadsheet to use over and over, it's worth thinking about the layout first. My notes on what to look for in a productivity template cover choices that make sorting easier later, such as one clear header row and no blank gaps.

Sorting a Google Sheets range that contains formulas

Sorting around formulas can make people nervous. Google's help says that sorting a filtered range doesn't change formulas pointing to cells inside it. Its example is that a formula reading =B2 stays =B2 after the sort. So you can sort lists with formulas in them without the references being rewritten, though it's still sensible to glance over the results.

If sorting or filtering is unavailable in Google Sheets

When the Create a filter option is greyed out, Google's help lists the usual culprits. Work through them in order:

1. Look for merged cells and unmerge them.
2. Look for hidden rows or columns and unhide them.
3. Check conditional formatting under Format, then Conditional formatting.
4. Check data validation rules under Data, then Data validation.
5. Check you have edit access. If you can only view, make a copy of the sheet and try again there.

If you're laying out a sheet that mirrors a document, such as order details, you may also like my walkthrough on filling in a Google Docs template correctly, which covers keeping structured information tidy.

Sorting in the Google Sheets app on a phone

Google's help page I read gives the computer steps in full and links to separate Android and iPhone versions. Menus vary by app version, so if you can't find the sort command on your phone, sort on a computer, where the steps above are documented, and check the result on your phone afterwards.

Frequently asked questions

How do I sort in Google Sheets?

Right-click a column letter and choose Sort sheet A to Z or Z to A, or highlight a range and use Data, then Sort range, then Advanced range sorting options.

How do I alphabetize in Google Sheets?

Sort A to Z. Right-click the column letter and click Sort sheet A to Z to alphabetize the column and keep every row together.

How do I sort by more than one column?

Highlight the range, open Data, Sort range, Advanced range sorting options, choose the first column, then click Add another sort column and pick the next.

Why is my header row sorted into the data?

You probably didn't tick Data has header row in Advanced range sorting options. Undo the sort, tick the box and sort again.

Can I sort without changing the sheet for everyone else?

Yes. Google says filters are visible to anyone with access, so create a filter view under Data to keep your sorting to yourself.