Sorting data in your spreadsheet can be a convenient way to find what you need but also a good way to organize it. We’ll show you how to alphabetize in Google Sheets so you can keep your data nice and neat.

You can sort your data alphabetically on the Google Sheets website or in the mobile app, although the website gives you a bit more flexibility. If you’re ready to get to it, let’s alphabetize that data.

Table of Contents
    How to Alphabetize in Google Sheets (Mobile and Computer) image

    Sort Alphabetically in Google Sheets on the Web

    If you use Google Sheets on the web, you can alphabetize your whole worksheet or a range of cells, like a column. Visit Google Sheets, sign into your Google account, and open a workbook to get started.

    Alphabetize a Sheet

    To alphabetize a sheet, you’ll use a specific column to sort by. The remaining columns in your sheet will update so that your data remains intact.

    Choose the column that you want to sort by and do one of the following:

    • Select the arrow to the right of the column header or right-click the column and pick Sort A – Z in the drop-down menu. To sort in reverse alphabetical order, pick Sort Z – A.
    • Go to the Data tab, move to Sort sheet, and pick Sort sheet by column (A to Z). To sort in reverse, pick Sort sheet by column (Z to A).
    Sort Alphabetically in Google Sheets on the Web image
    Online Tech Tips is reader-supported. We may earn a commission when you buy through links on our site. Learn more.

    Note: If you have a header row, these will be included in the alphabetization.

    Sort Alphabetically in Google Sheets on the Web image 2

    Alphabetize a Cell Range

    To alphabetize a particular cell range instead of the whole sheet, this is also an option. Just keep in mind that your other columns will not update to stay in sync with the sorted data.

    Go to the Data tab, move to Sort range, and pick Sort range by column (A to Z). To sort in descending order, pick Sort range by column (Z to A).

    Sort Alphabetically in Google Sheets on the Web image 3

    You’ll then see your range sorted alphabetically.

    Sort Alphabetically in Google Sheets on the Web image 4

    Alphabetize Multiple Cell Ranges

    If you have a sheet where you want to sort by a column alphabetically but also sort additional columns of data, you can perform an advanced sort.

    1. Select the data you want to alphabetize. This should include all cell ranges or columns.
    2. Go to the Data tab, move to Sort sheet, and pick Advanced range sorting options.
    Sort Alphabetically in Google Sheets on the Web image 5
    1. In the pop-up window, check the box at the top for Data has header row to exclude this data from the sort if you like.
    Sort Alphabetically in Google Sheets on the Web image 6
    1. Below, you’ll see the first column to sort by. Make sure to mark the A to Z option (or Z to A to sort in reverse).
    Sort Alphabetically in Google Sheets on the Web image 7
    1. Select Add another sort column.
    Sort Alphabetically in Google Sheets on the Web image 8
    1. Choose the second column to sort by in the drop-down box that appears and mark the A to Z option next to it as well (or Z to A to sort in reverse).
    Sort Alphabetically in Google Sheets on the Web image 9
    1. Continue this process for all columns you want to sort by in the cell range.
    2. When you finish, select Sort.
    Sort Alphabetically in Google Sheets on the Web image 10

    You’ll then see your data sorted alphabetically by each column, in order.

    Sort Alphabetically in Google Sheets on the Web image 11

    Sort Alphabetically in Google Sheets on Mobile

    You can alphabetize your spreadsheet in the Google Sheets app on your mobile device in just a few taps. Although the feature is more limited, you can still sort your data alphabetically.

    1. Open the Google Sheets app on Android or iPhone to the sheet you want to sort.
    2. You’ll then choose a column to sort by. This then sorts the entire sheet by that specific column.
    3. Tap the letter header at the top of the column to select it and then tap it again to open the small toolbar of actions.
    Sort Alphabetically in Google Sheets on Mobile image
    1. Use the arrow on the right side of the toolbar to move through the actions until you see the Sort A – Z option and select it.

    You’ll then see your sheet update to sort alphabetically by that column. The additional columns update just like on the website.

    Sort Alphabetically in Google Sheets on Mobile image 2

    When you want to sort data in your Google spreadsheet from A to Z, it’s easy to do. Now that you know how to alphabetize in Google Sheets, look at our tutorial for alphabetizing in Microsoft Excel too.

    Leave a Reply

    Your email address will not be published. Required fields are marked *