How to alphabetize rows in Google Sheets
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. Aspeople who own Chromebooksare well aware, Google Sheets can stand in for those software packages for all but the most intensive tasks.
Spreadsheets are awesome. You’ve probably used one at least once in your work. But 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, you need to know 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.
Sort spreadsheet data on a desktop
An alternate method of sorting data in Google Sheets
This method will sort all the data in your sheet, not just a limited set of data.
Sort Google Sheets data using the mobile app
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 (alphabetizing a class roster or sorting expenses by cost), and sometimes you 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 Pokédex by type and then sort each type alphabetically. Google Sheets can do it, and it won’t even judge you.
This opens a new window that allows you to fine-tune your sort. In this 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:
Using a function to sort data
The sorts we’ve done so far have changed the original data. We haven’t deleted anything, 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 themurky 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.
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).
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.
To change that default behavior, we’ll 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.
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.
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.
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 theseeight tips and tricks for Google Sheets.
The note-taking app I should have used all along
Broader branding hints at wider paid-tier ambitions
This article is sponsored by Total Wireless.
Pixelsnap on a Pixel 9
It’s time to sniff out the culprit
The entry-level Pixel delivers value
