Google Sheets: How to sort your data in alphabetical or numerical order

Main Image
  • Like
  • Comment
  • Share

Google Sheets is great when you are budgeting, reporting, and doing countless other activities. It is Microsoft Excel’s equivalent online version from Google that brings the same functionalities as the Microsoft variant but online. It is backed by the cloud which means everything you do is automatically saved on your Google Drive (or a shared one) instantly.

Google Sheets is amazing in doing complex calculations and operations on the data you feed. One of the features that Google Sheets brings onboard is sorting the data. You know how you would need to sort data in a certain way such as alphabetically or numerically which is by applying filters to organize data accordingly.

Sorting data is great as it lets you find a pattern and numerically or alphabetically sort the data. You can do so from A-Z and Z-A in a single multi-column selection. The feature is available on Android, iOS, and PC where the procedure on the latter differs from the former two.

How To Sort Data in Google Sheets On Desktop?

Let’s see how you can actually sort data on Google Sheets on its website on the desktop. Here’s how it works out.
Step #1: First up, launch Google Sheets on your PC or Mac.
Step #2: Next, open the spreadsheet where you want to make the sorting and changes.
Step #3: Select the group of cells where you want to apply the sorting function.

Google Sheets: How to sort your data in alphabetical or numerical order
Step #4: Next, right-click on the mouse where you will get a menu.
Step #5: Now, you need to scroll to the last option that says “View more cell actions”.
Step #6: Select “Sort Range”.

Google Sheets: How to sort your data in alphabetical or numerical order
Step #7: You will get a dialog box where you can make adjustments to get favorable results.

  • Check if you have ‘Data has header now’.
  • Next, tap on ‘Sort By’ and select the column which you want to make dominant when doing the actions. Select from the given column.
  • Next up, you can either select ‘A-Z’ or ‘Z-A’ which applies both Alphabetically and Numerically in ascending order (A-Z) and descending order (Z-A).

Google Sheets: How to sort your data in alphabetical or numerical order

  • If you want to sort on each of the columns separately, tap on the ‘Add another sort column’ and select the settings mentioned above and that’s all.

Google Sheets: How to sort your data in alphabetical or numerical order

Step #8: Tap on the ‘Sort’ button and there you are. You have successfully performed sorting action on Google Sheets on the selected columns.

How To Sort Data in Google Sheets On iOS and Android?

These are particular instructions on iOS and Android devices where you can use Google Sheets as well. Here’s how it works.
Step #1: Open Google Sheets on your phone.
Step #2: Next up, you need to open the spreadsheet and head over to the section where you need to make the required changes.
Step #3: Select the columns where you want to make the sorting action.

Google Sheets: How to sort your data in alphabetical or numerical order
[Follow either one of the methods mentioned below]

Method #1:
Step #4: Tap on the ‘More’ option in the top-right corner and select ‘Create a Filter’.

Google Sheets: How to sort your data in alphabetical or numerical order
Step #5: Once the filter is created, tap on the filter icon in the bottom right corner and you will get all actions you can perform here.

Step #6: Tap on “A→Z” or “Z→A” which is for sorting alphabetically or numerically as you wish.

Google Sheets: How to sort your data in alphabetical or numerical order

Method #2:
Step #4: Tap on the column letter.
Step #5: Tap on the top of the column again to open the menu and then, head over to ‘More’.
Step #6: Next, select from ‘Sort A-Z’ to ‘Sort Z-A’ to perform the said functions and that’s all.

Related Articles

ImageExclusive: Samsung Galaxy Z Flip 6 Specs Revealed Ahead of Unveiling at Paris Unpacked

Samsung’s upcoming Galaxy Unpacked event is scheduled for July 10, which is still several weeks away. At the upcoming unpacked event, Samsung is set to announce the Galaxy Z Flip 6, Galaxy Z Fold 6, Galaxy Watch 7, Galaxy Watch Ultra, and Galaxy Ring. Earlier, we revealed the 5K renders of the Galaxy Z Flip6 …

ImageHow to quickly share apps between Android phones using Nearby Share

Sharing your personal apps between Android phones has been a challenge for Android users overs. This is where Apple Air drop feature clearly shines as it allows instant sharing between iOS and Mac devices. In the past third-party apps like Shareit, SuperBeam addressed this problem to some extent but they where not as smooth as …

ImageHow to take backup of Google Photos & Google Drive data with Google takeout

Google Takeout might sound to you like a food delivery service but trust me it’s not. The Google Takeout is a data backup download service from the Alphabet subsidiary. With the help of the Takeout service, you can download all your data from Google Drive, Google Photos and other Google services into a single file that …

ImageGoogle’s Find My Device Network Finally Has A Launch Date, Sort Of

Last year, Google announced its Find My Device network, which would leverage the billions of Android devices out there. Like Apple’s Find My network, Google’s Find My Device would help locate missing smartphones, trackers, and compatible headphones. While the Alphabet-owned company was looking forward to an imminent launch, it got delayed as Google and Apple …

ImageFBI asks Google to handover YouTube user data related to a crypto laundering case

Who knew watching a YouTube video would land them in trouble? Turns out the Federal Investigation Bureau (FBI) has asked Google to hand over certain details about users who watch certain YouTube videos as a part of an ongoing large-scale criminal investigation. According to now-unsealed court documents as viewed by Forbes, the FBI orders Google …

Discuss

Be the first to leave a comment.