Google Sheets, much like Excel, is a great tool for storing and organizing data in a legible and comprehensive way. But what good is data if it’s all over the place? This quick tutorial will give you a step-by-step guide on quickly alphabetizing data in Google Sheets.

There are dozens of ways to sort data in Google Sheets. One of the easiest ways to do that is simply to alphabetize it. Doing so will give a clear structure to your Google Sheet document, and it takes only a couple of clicks. Here’s how to do it.

On desktop

  1. On your desktop, head to and open up the document you want to organize data in.
  2. Choose either a column or row you want to alphabetize in Google Sheets. Right-click the letter or number that corresponds.
  3. Tap Sort Sheet A-Z or Sort Sheet Z-A.

Once you do that, everything in that column or row will organize itself into the correct order, either from A to z or vice versa.

On Android or iOS

  1. On your Android or iOS device, head to the Google Sheets app.
  2. Once there, open your document.
  3. Tap the row number or column letter that corresponds to what you want to alphabetize.
  4. Tap the more icon.
  5. Hit Sort A-Z or Sort Z-A.

The process is fairly similar on both desktop and on mobile devices like a Samsung Galaxy phone. Either way, you need to select the entire column or row and then select Sort A-Z. Do note that you can also do this with numbers. There are no separate buttons for numbers. Rather, you can ask Google Sheets to alphabetize numerical data, and you’ll see the result you want.

This Google Sheets skill is a great tool to have in your back pocket, among many others. Being able to sort your data is one of the main skills you need to master in order to use Google Sheets effectively.

More on Google Workspace:

FTC: We use income earning auto affiliate links. More.

Check out 9to5Google on YouTube for more news:

You’re reading 9to5Google — experts who break news about Google and its surrounding ecosystem, day after day. Be sure to check out our homepage for all the latest news, and follow 9to5Google on Twitter, Facebook, and LinkedIn to stay in the loop. Don’t know where to start? Check out our exclusive stories, reviews, how-tos, and subscribe to our YouTube channel

About the Author

Andrew Romero's favorite gear