How to arrange google sheets in alphabetical order

Readers like you help support Android Police. When you make a purchase using links on our site, we may earn an affiliate commission. Read More.

Whether calculating your monthly household budget or cataloging your Pokémon collection, spreadsheets are invaluable for organizing and manipulating data. For decades, spreadsheets were the domain of businesspeople and accountants via often-expensive software packages. As people who own Chromebooks are aware, Google Sheets can stand in for Excel for all but the most intensive tasks.

ANDROIDPOLICE VIDEO OF THE DAY

Spreadsheets are awesome, and you've probably used Microsoft Excel at least once in your schooling. In case you're out of practice, the thing that sets a spreadsheet apart in a productivity suite of software is its ability to organize and manipulate data. We would have to write a book to cover all the ways you can manipulate data in Google Sheets. So instead, we'll talk about ways to organize it quickly.

Sorting data with Google Sheets

When organizing data in Google Sheets, the first thing you need to know is which data you want to sort. When sorting Pokémon, maybe you want to sort by the Pokémon number. If you're sorting your CD collection, you might want to sort by the year it was released. If you're organizing a list of Android Police writers, you could sort by their last names. A simple sort like this can be done in a few clicks.

Desktop

  1. Select any cell in the row with the data you want to sort by.

    01SimpleSort01

  2. Click Data from the menu at the top of the window.
  3. Hover over Sort sheet from the drop-down menu.
  4. Select either Sort sheet by column A (A to Z) or Sort sheet by column A (Z to A), depending on your needs.

    02SimpleSort02

Alternatively:

  1. Select the column with the data you want to sort by.
  2. Hover over the selected column head and click the triangle menu button.
  3. From the drop-down menu, select either Sort sheet A to Z or Sort sheet Z to A.

    04SimpleSort05-1

Mobile

  1. Select the column with the data you want to sort by tapping the column header.
  2. Tap the column header again to bring up a menu.

    2 Images

    05simpleSortMob

    06simpleSortMob

    Close

  3. Touch the three-dot overflow menu. On iOS, you will see an arrow instead of a three-dot menu.
  4. Select either Sort A-Z or Sort Z-A.

    07simpleSortMob

    Close

These sort options also work for numerical values. A to Z is analogous to sorting numbers from lowest to highest. Likewise, sorting from Z to A with numerical values arranges them from highest to lowest.

Advanced sorting with Google Sheets

Sometimes your sorting needs are simple, and all you want to do is alphabetize a class roster or sort your monthly expenses from cheapest to most expensive. But other times, you'll need to do something more complex. Perhaps you're running a competition and want to sort by category first and then sort by time within each category. Or maybe you want to sort a Pokedex by type and then sort each type alphabetically. Google Sheets can do it, and it won't judge you.

  1. Select the data you want to sort, not just the column with the data you want to sort by. Often, you can select the whole sheet.

    09AdvancedSort01

  2. Click Data from the menu at the top of the window.
  3. Hover over Sort range from the drop-down menu.
  4. Select Advanced range sorting options.

    10AdvancedSort02

This opens a new overlay window that allows you to fine-tune your sort. In our case, we want to sort our Pokémon by their primary type and then sort each type alphabetically based on the Pokémon's name. Here's how to get that done:

  1. If you have a header row (in this case, we don't), check this box. Sheets ignores the top row of the spreadsheet when sorting.

    11AdvancedSort03

  2. Select which column you'd like to sort the data by. Pokémon type is in column C, so we'll select that one.

    12AdvancedSort04

  3. Select either A→Z or Z→A.

    13AdvancedSort04

  4. To sort within each type after the data is organized by type, click Add another sort column.

    14AdvancedSort04

  5. Repeat steps 2 and 3, but select the column corresponding to the name of the Pokémon, which is column B in this example.
  6. Click Sort.

    15AdvancedSort06

Now that our lists of authors and Pokémon are sorted, a sort of anti-sort is buried in Google Sheets' menus.

  1. Select more than one cell from at least one row. For this example, we'll select columns A, B, C, and D.

    16Randomize01

  2. Right-click anywhere over the selected cells. Alternatively, hover over any column heading and click the triangle menu button.
  3. From the menu, hover over View more column actions, then select Randomize range.

    17Randomize02

  4. Here's the result:

    18Randomize03

Now that your data is jumbled, you may have noticed that the rows were randomly shuffled around, not the individual cells. When using the Randomize range option, one thing to watch out for is highlighting all the information you want to keep together. If we had only selected column B, the names of the Pokémon would have been shuffled without affecting the data in the other three columns.

Using a function to sort data

All the sorts we've done so far have changed the original data. Sure, we've been rearranging it, but often it's best to leave the original data alone. To create a sorted list of data without changing the original input, we'll have to delve into the murky world of spreadsheet functions. In this case, we'll use the SORT function.

At its simplest, the SORT function requires a range of data to sort, taking the form =SORT(first_cell:last_cell). Let's start with our randomized list of Pokémon.

  1. Highlight the cell in which you'd like the sorted data to begin appearing.

    01FindCellToOutputTo800

  2. In either the cell or the formula bar, type =SORT(A1:A151).

    02FirstSortFormula800

  3. Press Enter.

    03FirstFormulaOutput800

You should be able to see the problem right away. Because we only selected the Pokémon numbers in our sort range, that was all that was output. To fix this issue, expand the range to include all four columns by entering =SORT(A1:D151).

04SecondFormula800

By default, the SORT function organizes data in ascending order (lowest to highest or A to Z) based on the first column in the range.

05SecondFormulaOutput800

If we want to change that default behavior, we need to add two or more arguments to our SORT function. We need one argument to indicate which column has the data by which we want to sort and a second to indicate whether to sort the data in ascending or descending order.

Our new function takes the form =SORT(first_cell:last_cell, sort_column, is_ascending). Let's alphabetize our list of Pokémon from Z to A instead of organizing it based on a number to get a better idea of what this looks like.

  1. Highlight the cell where you'd like the sorted data to begin appearing.
  2. Type =SORT(A1:D151, 2, FALSE).

    06ThirdFormula800

  3. Press Enter. The 2 tells the function to sort the range of data based on the data in column 2. The FALSE indicates that we do not want to sort it in ascending order. In this case, it will be sorted in reverse alphabetical order.

    07ThirdFormulaOutput800

We can also sort within our sort. Let's say we want to organize our Pokémon by their type, but we want the Pokémon of each type to be organized alphabetically. Here's what that looks like.

  1. Highlight the cell in which you'd like the sorted data to begin appearing.
  2. Type =SORT(A1:D151, 3, TRUE, 2 TRUE).

    08FourthFormula800

  3. Press Enter. The 3, TRUE argument tells the function to sort by the data in column 3 in ascending order. The 2, TRUE argument indicates that items with the same value in column 3 should be sorted by the data in column 2 in ascending order.

    09FourthFormulaOutput800

If you add more than one argument to a SORT function, the arguments must be in pairs. For example, typing =SORT(A1:D151, 2) results in an error. If you indicate a column by which to sort, you must also indicate how you want it to be sorted.

10FunctionError800

Make your data work for you

So what is all this good for? That depends on your use case. If you're organizing a race, you might want an alphabetical list of participants or a list of the finishers from first to last. If you're running a business, you might want to organize your data to see which employee had the highest sales on a given day.

The use cases for spreadsheets are endless, but one of the first things you must learn before getting any value out of them is how to organize information. If sorting is trivial for you, improve your skills with these eight tips and tricks for Google Sheets.

How do I put Google Sheets in alphabetical order?

On your computer, open a spreadsheet in Google Sheets. At the top, right-click the letter of the column you want to sort by. Click Sort sheet A to Z or Sort sheet Z to A.

Can you auto alphabetize in Google Sheets?

Alphabetizing Data Using In-Built Sort Options If you just want to alphabetize the data and get static value, you can use the in-built sorting options in Google Sheets. Click on the 'Sort range' option. The Sort Range dialog box will give you advanced range sorting options.

How always sort from A to Z in Google Sheets?

Select the column to sort by. To do this, select any cell of the required column. Go to the Data menu and select the alphabetical order for sorting: Sort sheet by {selected-column} , A to Z.

How do you alphabetize multiple sheets in Google Sheets?

sort-tabs.txt.
Copy/Paste the information below to the clipboard..
Open the spreadsheet whose sheets need to be alphabetised..
Choose Tools > Script editor > Blank (this opens a new tab in the browser).
Press Control+A followed by Control+V copy and paste the script in..
Press Control+S to save the script..