How to sort alphabetically in Google Sheets on desktop or mobile, and organize your spreadsheet data

You can sort data alphabetically in Google Sheets on desktop or mobile.

caption
You can sort data alphabetically in Google Sheets on desktop or mobile.
source
Shutterstock

Google Sheets is Google’s answer to Excel, helping you to create a multitude of spreadsheets within the Google Office Suite.

When making a spreadsheet, it’s important to be able to sort your data in different ways, depending on context, in order to help you make sense of it. For example, if you’re making a spreadsheet to keep track of donations, sorting from highest to lowest or lowest to highest might be helpful.

Spreadsheets aren’t all about numbers, though. What if you want to keep track of something else, like people?

In that case, it would be more helpful, perhaps, to sort alphabetically. Keeping track of people by first or last name from A to Z is one of the most common and familiar means of organization to most people – so if you’re doing something like making a guest list or trying to keep track of preferences for a gift exchange, you’ll probably want to sort out the names that way.

Here’s how to sort alphabetically in Google Sheets, on desktop and mobile.

Check out the products mentioned in this article:

Lenovo IdeaPad 130 (From $299.99 at Best Buy)

MacBook Pro (From $1,299.99 at Best Buy)

iPhone 11 (From $699.99 at Best Buy)

Samsung Galaxy S10 (From $899.99 at Best Buy)

How to sort alphabetically in Google Sheets using your computer

1. Open Google Sheets on your PC or Mac computer. Log in and open the sheet that you want to sort.

2. Click and drag your mouse to highlight the data range you want to sort.

Highlight your desired range.

caption
Highlight your desired range.
source
Melanie Weir/Business Insider

3. Click the “Data” button in the menu at the top of the screen.

4. In the dropdown menu, click “Sort Range.”

Click

caption
Click “Data” and then “Sort Range.”
source
Melanie Weir/Business Insider

5. In the pop-up window, be sure to specify whether or not your columns have headers. If they do, check the box at the top.

  • If you want to sort an entire data table with headers, be sure to freeze the first row. Then, at the top of your spreadsheet, click the letter of the column you want to sort by. Right-click the letter, then click “Sort Sheet A > Z.”

Right click the column, then click Z.”” class=” bi_image size-medium wp-image-1224877″ bisrc=”https://static.businessinsider.com/image/5e1cbf94b2e66a79331ab3b5.jpg”/>

caption
Right click the column, then click “Sort Sheet A > Z.”
source
Melanie Weir/Business Insider

6. Select the column that you wish to sort alphabetically, then choose either A to Z or Z to A.

7. When you are sure everything is correct, click “Sort.”

Choose a column to sort by and how to sort, then click

caption
Choose a column to sort by and how to sort, then click “Sort.”
source
Melanie Weir/Business Insider

How to sort alphabetically in Google Sheets using your mobile device

1. Open the Google Sheets app on your iPhone or Android.

2. Select the spreadsheet that you want to edit.

3. Tap the gray box in the top-left corner of the spreadsheet to select the whole document.

4. Click the three dots in the upper-right corner of your screen.

Select your data, then click the three dots in the top-right corner.

caption
Select your data, then click the three dots in the top-right corner.
source
Melanie Weir/Business Insider

5. In the side menu, tap “Create a filter.”

Tap

caption
Tap “Create a filter.”
source
Melanie Weir/Business Insider

6. Tap the green triangle next to the column you want to sort.

Tap the green triangle next to the column title or number.

caption
Tap the green triangle next to the column title or number.
source
Melanie Weir/Business Insider

7. Under “Sort and filter,” tap A > Z or Z > A.

Tap Z.”” class=” bi_image size-medium wp-image-1224882″ bisrc=”https://static.businessinsider.com/image/5e1cc031f4423177990149e3.jpg”/>

caption
Tap “A > Z.”
source
Melanie Weir/Business Insider

Related coverage from How To Do Everything: Tech: