How to Sort in Google Sheets (from the Apps or a PC)

-

|

This Itechguide teaches you how to sort in Google Sheets. The guide offers steps to sort on Google Sheets from the Android/iPhone App or from a PC.

1
How to Sort in Google Sheets (from a PC)

How to Sort in Google Sheets (from a PC)
  • Open Sheets.Google.com from your PC and login with your Google Account.
  • Then open the Google Sheets document you want to sort. To open an existing document click File then select Open. Navigate to the Google Drive location you saved the document and open it.
How to Sort in Google Sheets (from a PC)
  • To sort a data in the document, click the column header to select all the columns. In this example, to select Column A, I clicked on the top of the column.
How to Sort in Google Sheets (from a PC)
  • Once the data you want to sort is selected, click the Data tab. Then for quick sorting, select any of the highlighted options – Sort sheet by Column A, A – Z, Sort sheet by Column A, Z – A …. For more refined sorting see below…
How to Sort in Google Sheets (from a PC)
  • Alternatively, to modify the sorting click Sort range.
  • This gives you more control over how you want to sort the data. As an example you can check the Data has a header row box – if there is a header. You could also Add another sort column – if you have more columns. Finally, you could sort by A – Z or Z – A. When you finish modifying your sorting criteria, click Sort.

2
How to Sort in Google Sheets (from Android App)

How to Sort in Google Sheets (from Android App)
  • Open Google Sheets for Android App.
How to Sort in Google Sheets (from Android App)
  • Then open the Google Sheets document with the data you want to sort. If you opened the document recently, you will find it beneath Last opened by me.
How to Sort in Google Sheets (from Android App)
  • Alternatively, you could open the document from Google Drive. To access Google Drive, click the folder icon on the top right of Google Sheets App. Then select Google Drive.
How to Sort in Google Sheets (from Android App)
  • Click the column you want to sort. Then click it again to display a menu.
  • To display another menu, click the 3 dots in the first menu. From the second menu, to sort in Google Sheets, select your sort option – Sort A – Z or Sort Z – A (See the second image below)

3
How to Sort in Google Sheets (from iPhone App)

How to Sort in Google Sheets (from iPhone App)
  • Open the iPhone App on your iPhone.
How to Sort in Google Sheets (from iPhone App)
  • Then open the document with the data you want to sort. You could open the document from beneath Last opened by me or from Google Drive. To access Google Drive, click the folder icon on the top right of the App.
  • Once you open the document, click the column with the data you want to sort. Then click it again to display a menu.
  • To display sort options click the arrow beside Cut Copy AutoFill menu 5 times until Sort A – Z and Sort Z – A menu is displayed (See the second image below). To sort in Google Sheets, click one of the sort options.

It is this easy to sort in Google Sheets! I hope you found the guide useful and easy to follow.

Have a question, comment or feedback? Use the “Leave a Reply” form found at the end of this page.

If you enjoyed this Itechguide and want to read more of our Google guides, visit our Google How To page.

  • Was this post Helpful?
  • YesNo

LEAVE A REPLY

Please enter your comment!
Please enter your name here

ADVERTISEMENTS

FEATURED POSTS

Best Christian Movies on Netflix

The 10 Best Christian Movies on Netflix

This Itechguide reviews the 10 best christian movies on Netflix. The movies are listed in reverse order – with the 10th movie...
How to Change Orientation in Google Docs

How to Change Orientation in Google Docs

This Itechguide teaches you how to change orientation in Google Docs. The guide covers steps to change orientation in Google Docs from...
How to Delete Google Photos

How to Delete Google Photos

This Itechguide teaches you how to delete Google Photos. The guide offers steps to delete Google Photos from the Google Photos App...
How to Install Windows 10 1909 Update Manually

How to Install Windows 10 1909 Update Manually

This Itechguide teaches you how to install Windows 10 1909 update manually. Windows 10 1909 (otherwise known as Windows 10 November update)...
How to Create a Poll on Facebook

How to Create a Poll on Facebook

This Itechguide teaches you how to create a poll on Facebook. You can create a poll on Facebook from a Facebook page...

AMAZON DEALS

TRENDING POSTS

Remote Desktop Connection

Remote Desktop Connection an Internal Error Has Occurred [Fixed]

Introduction I recently received the error message "Remote Desktop Connection an Internal Error Has Occurred". It was strange because...

Find My Samsung: Register and Use Samsung Find my Mobile

Introduction Ever wondered how you could find your Samsung phone if you lost it? Find my Samsung or Samsung...
What is the Difference Between PowerShell and CMD?

Windows Powershell vs CMD: Differences and Similarities

Introduction This short guide compares Windows PowerShell vs CMD (Windows command prompt). I will cover the history and nature...
Spotify No Longer Supports this Version of Microsoft Edge

Spotify No Longer Supports this Version of Microsoft Edge [Fixed]

Introduction When you open Spotify web player on Microsoft Edge, you may receive the error message "Spotify No Longer...
Windows 10 Won't Boot

Windows 10 Won’t Boot With Black Screen? 3 Ways to Fix It

Why Won't Windows 10 Boot Up? If your Windows 10 stops with a black screen, the first question in...

ADVERTISEMENTS

BEST OF ITECHGUIDES

How to Empty Google Drive Trash

How to Empty Google Drive Trash (from the Drive App or a PC)

Introduction This is a demo guide on how to empty Google Drive trash. One of the reasons you may...

How to Map Network Drive in Windows 10 (5 Methods)

Introduction This guide demos 5 methods to Map Network Drive in Windows 10. Options to...
How to Remove Footer in Google Docs

How to Remove Footer in Google Docs

This Itechguide teaches you how to remove footer in Google Docs. The guide offers steps to remove footer in Google Docs from...
How to Add Thumbnail to YouTube Video

How to Add Thumbnail to YouTube Video

This Itechguide teaches you how to add thumbnail to YouTube video. The guide offers steps to add thumbnail to YouTube video for...
Windows Cannot Find GPEDIT.MSC or GPEDIT.MSC Not Found [Fixed]

Windows Cannot Find GPEDIT.MSC or GPEDIT.MSC Not Found [Fixed]

Introduction If you try opening gpedit.msc from Windows 10 Home you will receive the error message windows cannot find...

RECENT POSTS

Best Crime Documentaries on Netflix

The 10 Best Crime Documentaries on Netflix

This Itechguide reviews the 10 best crime documentaries on Netflix. The documentaries are listed in reverse order – with the 10th documentary...
Best Netflix Series

The 10 Best Netflix Series

This Itechguide reviews the 10 best Netflix series. The series are listed in reverse order – with the 10th series on top....
How to Upload Video to Facebook

How to Upload Video to Facebook

This Itechguide teaches you how to upload video to Facebook. The guide covers steps to upload video to Facebook from a PC...
How to Delete a YouTube Video

How to Delete a YouTube Video

This Itechguide teaches you how to delete a YouTube video. The guide covers steps to delete a YouTube video from a PC...
How to Upload a PowerPoint to YouTube

How to Upload a PowerPoint to YouTube

This Itechguide teaches you how to upload a PowerPoint to YouTube. YouTube accepts .mp4 video formats. So, before...

AMAZON DEALS

MUST READ

spotify subscription

How to Subscribe to Spotify Premium

Introduction Paid Spotify subscription (premium) has a lot more benefit compared to the free one. Some of the benefits...
preparing to configure windows stuck

How to Fix Windows 10 Stuck at “Preparing To Configure Windows..”

Introduction Here is how this plays out: Windows update notifies you of available updates. You download and install them....
Best Standup on Netflix

Top 10 Best Standup on Netflix

This Itechguide reviews the 10 best standup on Netflix. The standups are listed in reverse order – with the 10th standup on...
How to Install RSAT in Windows 10 (3 Methods)

How to Install RSAT in Windows 10 (3 Methods)

Introduction This guide demos how to Install RSAT in Windows 10. Starting with Windows 10...
windows 10 lock screen timeout

How to Change Screen Time Out Setting in Windows 10

Introduction There are two easy ways to change Windows 10 lock screen timeout settings: Desktop...

AMAZON DEALS

By using this website you agree to accept our Privacy Policy and Terms & Conditions