123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Computers >> View Article

How To Sort Data Alphabetically In Google Sheets

Profile Picture
By Author: Aida Martin
Total Articles: 401
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

Google Sheet and MS Excel have various similar features. The capability to sort and filter the data numerically and alphabetically is one of the popular features of MS Excel. You will notice the same feature is also in the Google Sheets. But the method to complete this procedure is a little bit different. Here’s how to sort alphabetically in Google Sheets.

Steps for Data Sorting in Google Sheets

•    Go to your default internet browsers such as Mozilla Firefox or Opera.

•    You need to go to the spreadsheet in the Google Sheets.

•    Now, you have to bookmark the cell or cells which you wish to sort in Google Sheets. Here’s how:

1.    In case you wish to bookmark a particular cell, then right-click on it.

2.    If you want to bookmark many cells, then left-click on the first cell.

3.    Keep pressing on the Shift key on the system keyboard.

4.    After that, you have to left-click in the last cell.

5.    You can also choose many cells by left-clicking a particular cell and after that, keep pressing on the Control key on the system ...
... keyboard.

6.    Then, you have to left-click on any other cell.

7.    Choose all the content in the Google Sheet, press on the upper left-hand side of the Google Sheet.

8.    Tap on the Control and A keys together.

•    Press on the “Data ” option and after that, choose the Sort Range option by going to the options available on display.

•    In case there are the titles placed in each section, then you need to insert a tick symbol in the box given below the Data has header row option.

•    Choose the section you wish to sort by adjusting the Sort by to the section.

•    Choose the alphabetical order by pressing on the A to Z or Z to A option.

•    Complete this procedure by tapping on the Sort option.

Steps to Create a Filter View in Google Sheets

•    Open your default browsing application.

•    Click on the spreadsheet provided in the Google Sheets.

•    Tap on the “Data” option and after that, choose the Filter views option.

•    Now the filter view gets automatically saved.

•    Sort and filter the file which you want.

•    Now, you need to close the filter view window by tapping on the “X” button located in the upper right-

hand side of the spreadsheet.

•    Tap on the Cogwheel symbol given at the upper right-hand side of the spreadsheet by choosing the options listed below:

1.    Duplicate

2.    Delete

3.    Rename

4.    Update Range

Ellen Cooper  is a technology enthusiast who loves writing about new advancements and IT threats on a regular basis. Her work focuses on the latest advancements in the realm of technology, social media, and cyber security at norton.com/setup.

Source:- http://nortonnorton.uk/how-to-sort-data-alphabetically-in-google-sheets/

More About the Author

IT expert having deep knowledge about PC antivirus products. Mainly researching and writing blogs. https://askmeyp.com/ | https://m4activate.co.uk/ | https://n4setup.co.uk/

Total Views: 336Word Count: 436See All articles From Author

Add Comment

Computers Articles

1. Choosing The Right Printer Repair Company: A Comprehensive Guide
Author: Vivek Singh

2. Improving Defences Proxy Device(defense In Depth)
Author: Wisemonkeys

3. Yetishare File Hosting Script: Simplify Your File Hosting Needs
Author: Adam Wilson

4. What Google’s New Ai Search Engine Mean For Seo And Paid Ads
Author: Mitesh patel

5. How To Avoid Spam Emails In Sbcglobal Email - A Complete Guide
Author: Twinkle Chandan

6. Security In Cloud Computing Environment Using Cryptography - Rushabh Modi
Author: Wise Monkeys

7. A-b-c Of Networking: Part-2 (components)
Author: Wisemonkeys

8. How To Maximize Product Sales With Uae Mobile Database
Author: DatabaseME

9. A-b-c Of Networking: Part-1 (basics)
Author: Wise monkeys

10. Highly Recommended Ruby On Rails Development Company - Jetruby
Author: jetruby

11. Having An Computer Issue ? Call Expert Geeks
Author: Go2Geeks

12. 5 Tips To Home Appliance Repair
Author: Vivek Singh

13. The Impact Of Blockchain Technology On The Development Of Sports Betting Software
Author: Jennifer

14. Optaplanner Software Development: Top Business Use Cases
Author: Anirudh Bhardwaj

15. Why Do Entrepreneurs Like To Start The Binance-like Crypto Exchange Platform?
Author: pambeesly

Login To Account
Login Email:
Password:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: