• Skip to main content
  • Skip to primary sidebar

Technipages

Smart phone, gadget and computer tutorials

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About
Google Sheets: Alphabetizing a List

Google Sheets: Alphabetizing a List

Posted on December 29, 2019 by Mel Hawthorne Leave a Comment

Popular spreadsheet program Google Sheets can do a whole lot of cool stuff, but not every function and every option is easy to find. This sadly includes common and very necessary functions – such as sorting data according to the alphabet.

Thankfully, it’s actually quite easy to do so! Simply follow the instructions below.

First, click on the field above the row of data you want to sort by – in other words, if, in a user database, you want to sort by last name, click on the field above the column that has all the last names in it. Said column will be highlighted.

Right-click anywhere within the highlighted area and a large menu will pop up – look for the option to “Sort Sheet A -> Z” or “Sort Sheet Z -> A”, depending on which way around you want it to be.

Option to sort alphabetically

Be aware that doing this won’t just change up the column you’ve selected, but will move the entire rows. In other words, it won’t just order the last names and leave everything in place but re-order all the records, so don’t worry about accidentally mixing things up too much!

Tip: You can do this to any column you’d like – it also works on fields that contain numbers. While it will still say A->Z, it will order them numerically, 1->9.

You Might Also Like

  • Google Sheets: Make Dropdown ListGoogle Sheets: Make Dropdown List
  • How to Convert Google Sheets to PDFHow to Convert Google Sheets to PDF
  • Google Sheets: How to Shade Every Other RowGoogle Sheets: How to Shade Every Other Row
  • Troubleshooting Google Sheets Goes BlankTroubleshooting Google Sheets Goes Blank
  • Google Sheets Won't Let Me Type - Fix GuideGoogle Sheets Won't Let Me Type - Fix Guide
  • Troubleshooting Google Sheets Not PrintingTroubleshooting Google Sheets Not Printing
  • Troubleshooting Google Sheets Not WorkingTroubleshooting Google Sheets Not Working
  • How to Highlight Text in Google SheetsHow to Highlight Text in Google Sheets
  • How to Spell Check in Google SheetsHow to Spell Check in Google Sheets

Filed Under: Software Tagged With: Google Sheets

Reader Interactions

Did this help? Let us know! Cancel reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • Slack: How To See Message Timestamps in a 24-Hour Clock Format
  • Slack: How To Change When Channels Are Marked as Read
  • Slack: How To Hide Inline Media
  • Fix: Empty File Appeared on Windows 10 Desktop
  • Stop MS Teams Users From Creating Channels and Teams
  • How to Fix Microsoft Teams Error c0292007
  • Microsoft Teams: How to Lock Files
  • Microsoft Teams: Disable ‘How Was the Call Quality?’

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

Follow me on Twitter, or visit my personal blog.

You May Also Like

  • Top 10 Google Chrome Alternatives to Surf Better

© Copyright 2021 Technipages · All Rights Reserved · Privacy