How to Alphabetize in Google Sheets

Sorting data alphabetically in Google Sheets is one of those tasks that seems like it should be obvious - and it mostly is, once you know where to look. Whether you're organizing a contact list, cleaning up inventory data, or arranging student names for a class roster, Google Sheets gives you several ways to get your data in A-to-Z order. Some take two clicks. Others give you way more control over how the sort actually works.

This guide walks through four different methods, from the simplest menu-click approach to using Sheets formulas that automatically keep your data sorted as you add new entries. Pick whichever one fits your situation.

Method 1: Sort from the Data Menu

This is the fastest way to alphabetize and the one most people reach for first. It rearranges your data directly in the sheet - no formulas, no extra columns.

1. Select the cells you want to sort. If your data has multiple columns (like names in column A and emails in column B), select all the columns so related data stays together.
2. Click Data in the top menu bar.
3. Choose "Sort sheet by column A, A→Z" for alphabetical order. Pick "Z→A" if you want reverse alphabetical.

If you selected a specific range rather than the whole sheet, you'll see "Sort range by column A, A→Z" instead. Both work the same way - the difference is whether it moves the entire sheet's rows or just the rows in your selection.

One thing to watch out for: if your data has a header row (like "Name" or "Company"), make sure to check the "Data has header row" checkbox in the sort dialog. Otherwise Sheets will sort your header right into the middle of your data, which is annoying to fix.

Method 2: The SORT Function

The SORT function is better when you want to keep your original data untouched and display a sorted copy somewhere else. It's also dynamic - when you add or change entries in the source range, the sorted output updates automatically.

The basic syntax looks like this:

Here's what each part means:

• range - The cells containing your data (e.g., A2:A50 or A2:C50 for multiple columns)
• sort_column - Which column number to sort by. Use 1 for the first column in your range, 2 for the second, etc.
• is_ascending - TRUE for A→Z, FALSE for Z→A

So if you have names in A2 through A20 and you want them alphabetized in column C, you'd click cell C2 and type:

For multi-column data where you want to sort by one column but keep everything together:

That sorts all three columns based on column A's alphabetical order. The data in columns B and C follows along so your rows stay intact.

You can also sort by multiple columns. Say you have a list of people with last names in column A and first names in column B, and you want to sort by last name first, then by first name within matching last names:

Method 3: Right-Click Sort

If you don't want to navigate through menus, there's a shortcut. Right-click on any cell in the column you want to sort, and you'll see "Sort column A → Z" and "Sort column Z → A" right in the context menu.

This sorts the entire sheet by that column, similar to the Data menu approach. It's convenient but doesn't give you the "Data has header row" option, so if your header gets sorted into the wrong place, use Method 1 instead where you can toggle that checkbox.

Method 4: Filter Views for Shared Sheets

Here's a situation that trips people up: you're working in a shared Google Sheet with five coworkers, and you want to sort the data alphabetically to find something. But if you sort the sheet, everyone else sees their data rearranged too - which might mess up what they're doing.

Filter Views solve this. They let you sort and filter your view of the data without affecting anyone else.

1. Go to Data > Create a filter (or Data > Filter views > Create new filter view).
2. You'll see small dropdown arrows appear in each column header.
3. Click the arrow in the column you want to sort.
4. Select "Sort A → Z".

Your view changes, but your coworkers still see the original order. When you're done, close the filter view and the sheet goes back to normal. This is especially useful in team spreadsheets, class rosters, or any document where multiple people are working at the same time.

Combining SORT with FILTER

Once you're comfortable with the SORT function, you can nest it with FILTER to get really specific results. Say you have a product list in column A and categories in column B, and you want an alphabetized list of just the products in the "Electronics" category:

The FILTER pulls out only the rows where column B says "Electronics," and the SORT arranges those filtered results in alphabetical order. This is powerful for large datasets where you need a sorted subset without manual work.

Handling Common Sorting Problems

A few things can make alphabetical sorting behave unexpectedly in Google Sheets:

• Leading spaces - If someone typed " Apple" with a space before the A, it'll sort differently than "Apple" without the space. Use =TRIM(A2) to strip extra whitespace, or apply it across a range with =ARRAYFORMULA(TRIM(A2:A100)).
• Mixed case - Google Sheets sorts uppercase and lowercase the same way by default (it's case-insensitive), so "apple" and "Apple" are treated equally. This is usually what you want.
• Numbers stored as text - If you have "Item 1", "Item 10", "Item 2" in your list, alphabetical sorting puts "Item 10" before "Item 2" because it compares character by character. To sort numerically, you'd need to extract the numbers into a separate column and sort by that.
• Special characters - Items starting with symbols, numbers, or accented characters sort before or after standard letters depending on the character. If this causes problems, consider adding a "sort key" column with normalized text.

When to Use Each Method

Frequently Asked Questions