How to Alphabetize in Google Sheets (Sort Alphabetically)

4 Minutes

Having your data arranged is very important to help you visualize and understand it. Most often, we will sort by a number or values but there will also be times when we want to arrange text such as names, places or codes sequentially. In this article we will show you exactly how to sort alphabetically in Google Sheets to create effective data sets in two easy methods.

How to Sort Alphabetically in Google Sheets

Method 1: Using The Sort Range Feature

Say you have more than 100 participants for your marathon. To be able to make registration on the event day quicker, you decide to alphabetize the participant names and assign them to different booths. Doing this manually is a very tedious process, lets see how to sort alphabetically to make this easier:

  1. Select all your data.
Alphabetize lists on Google Sheets

Press any cell within your datasheet and press Ctrl+A (Windows) or Command+A (Mac) to select all contents for huge sets of data.

  1. Go to Data -> Sort Range -> Advanced range sorting options.
Using Google Sheets to arrange data
  1. Adjust your advanced options based on your data.
Advanced options for arranging columns

Since the data has headers, we will check “Data has header row” but you can skip this if your data has none.

You can also choose which column/header to sort by using the dropdown menu and whether you want it to be from A to Z or in reverse. 

Tip: If you need to sort one column AFTER another, simply press “Add another sort column” for the succeeding columns to be sorted out. You can do this for as many columns as you have.

  1. Press Sort.

Now your data is sorted by full name starting from A. You can use the same procedure to arrange according to last names.

Final Output in Google Sheets

Method 2: Using Filters

  1. Select your data
Selecting your data
  1. Go to Data -> Create a filter
Creating a filter in Google Sheets

Pressing Create a Filter will make filter icons appear beside each individual column header.

  1. Press the Filter icon beside the column you want to alphabetize 
Using filters to arrange data
  1. Select what order you want your data to be sorted by
Selecting A-Z Option to arrange your data

The contents of the adjacent columns will also reflect the change in order. You can do this to Alphabetize any column in Google Sheets.

Lido is a new spreadsheet built for automation. Trigger emails, slack messages, and more directly from a spreadsheet.