• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

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

Google Sheets: Alphabetizing a List

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 List
    Google Sheets: Make Dropdown List
  • How to Convert Google Sheets to PDF
    How to Convert Google Sheets to PDF
  • Google Sheets: How to Shade Every Other Row
    Google Sheets: How to Shade Every Other Row
  • Troubleshooting Google Sheets Goes Blank
    Troubleshooting Google Sheets Goes Blank
  • Google Sheets Won't Let Me Type - Fix Guide
    Google Sheets Won't Let Me Type - Fix Guide
  • Troubleshooting Google Sheets Not Printing
    Troubleshooting Google Sheets Not Printing
  • Troubleshooting Google Sheets Not Working
    Troubleshooting Google Sheets Not Working
  • How to Highlight Text in Google Sheets
    How to Highlight Text in Google Sheets
  • How to Spell Check in Google Sheets
    How to Spell Check in Google Sheets

Filed Under: Software Tagged With: Google Sheets

Reader Interactions

Did this help? Let us know!

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

  • What Is Host Memory Buffer (HMB) in SSD?
  • DRAM on an SSD: Is It Something You want?
  • 5 Free Android Apps to Remove Red Eye
  • Windows 11: How to Change the Primary Mouse Button
  • Windows 11: Use Fonts and Make Your Text Fantastic
  • Windows 11: How to Manage the Recycling Bin
  • How to Enable Dark Mode in Firefox
  • Windows 11: How to Add Clocks with Different Time Zones

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.

You May Also Like

  • Top 10 Google Chrome Alternatives to Surf Better

© Copyright 2022 Technipages · All Rights Reserved · Privacy