How to Sort on Google Sheets on PC or Mac

This wikiHow teaches you how to sort data in Google Sheets when you’re using a computer.

Steps

  1. Image titled Sort on Google Sheets on PC or Mac Step 1
    1
    Go to https://sheets.google.com in a web browser. If you’re not already signed in to your Google account, sign in now.
  2. Image titled Sort on Google Sheets on PC or Mac Step 2
    2
    Click the sheet you want to edit.
  3. Image titled Sort on Google Sheets on PC or Mac Step 3
    3
    Click the letter above the column you want to sort. The entire column is now highlighted.
  4. Image titled Sort on Google Sheets on PC or Mac Step 4
    4
    Click the Data menu. It’s above the icon bar at the top of Sheets. The remaining steps will describe different ways to sort your data.
  5. Image titled Sort on Google Sheets on PC or Mac Step 5
    5
    Sort the selected column’s data without affecting other rows. Here’s how:
    • Click Sort range…
    • If there is a header row at the top of the sheet (a row with titles/names of columns), check the box next to “Data has header row.”
    • Select A → Z to sort in alphabetical/numerical order, or Z → A to do so in reverse.
    • Click Sort. The data is now rearranged.
  6. Image titled Sort on Google Sheets on PC or Mac Step 6
    6
    Sort the entire sheet in alphabetical or numerical order. Click Sort sheet by column (letter), A – Z to sort the entire sheet alphabetically (or in numerical order) based on the selected column. To sort the sheet reverse-alphabetically, click Sort Sheet by column (letter), Z – A instead.

You Might Also Like

Sign Out of Your Google Account on All Devices at Once
How to
Sign Out of Your Google Account on All Devices at Once
Turn Off Google Safesearch
How to
Turn Off Google Safesearch
Fix the "Google Play Store Has Stopped" Error
How to
Fix the "Google Play Store Has Stopped" Error
Write a Review on Google
How to
Write a Review on Google
Search by Image on Google
How to
Search by Image on Google
Buy a Google Play Gift Card Online on Android
How to
Buy a Google Play Gift Card Online on Android
Access Google Assistant
How to
Access Google Assistant
Restore Google Authenticator
How to
Restore Google Authenticator
Make a Google Account Without Gmail
How to
Make a Google Account Without Gmail
Get a Google Voice Phone Number
How to
Get a Google Voice Phone Number
Apply a Formula to an Entire Column on Google Sheets on PC or Mac
How to
Apply a Formula to an Entire Column on Google Sheets on PC or Mac
Create a Google Profile
How to
Create a Google Profile
Use Google Translate
How to
Use Google Translate
Sort by Number on Google Sheets on PC or Mac
How to
Sort by Number on Google Sheets on PC or Mac

About This Article

Nicole Levine, MFA
Written by:
Nicole Levine, MFA
Tech Specialist
This article was written by Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 2,597 times.
How helpful is this?
Co-authors: 1
Updated: January 8, 2018
Views: 2,597
Categories: Google Applications