347 647 9001+1 714 797 8196Request a Call
Call Me

Important Tips for Using Google Spreadsheets

February 17, 2015
, ,

We are sure that after reading our previous article, you are through with the Basics of Google Spreadsheets. In this article, we bring to you some more important aspects of Google Spreadsheets.


After filling the data in the spreadsheet, sometimes you may wish to re-organize it and that is where sorting feature helps. Sorting helps you to change the order of your data.

How to Sort the data in Google spreadsheets?

Step 1: While sorting the data in a sheet, there may be some rows or columns that you may want unchanged. To keep the rows or columns unchanged freeze them. Like in the image below we are freezing the 1st row.

Freeze rows in Google spreadsheets

Step 2: The header row freezes. Now select any cell from the column that needs to be sorted. In our example, we shall sort the Marks column in descending order to know which student has scored more.

Step 3: Click on Data from the ribbon and select sort sheet by column A-Z for ascending order or select Sort sheet by Column Z-A for descending.

Using sort function in Google Spreadsheet

Step 4: You will see that your data has been sorted.

Sorting data in Google spreadsheet


Applying the filters in your data can bring a lot of ease and convenience. It will help you to display only the data that interests you.


How to Filter data in Google Spreadsheets?

Step 1: Click on any cell that contains data in your spreadsheet. Click on the filter button available in the ribbon menu. (Refer image 4)

Filter icon in Google spreadsheet

Step 2: A Dropdown shall appear in each of the header.

How to filter data in Google spreadsheet

Step 3: Click on the dropdown of the column which requires filtering. You will see that a new dialog box has appeared which consists of checklist.

Filtering data in Google spreadsheet

Step 4: Select the data that you wish to display. In our example we have selected marks that are above 60.

Filter option in Google spreadsheet

Keyboard Shortcuts

Google Spreadsheet shortcuts

We hope that these tips will help you in using Google spreadsheets in an easier way. You can share your views with us in the comments box below.


About the Author

Trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe, it is one of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, and Operational Risk Modeling. EduPristine has conducted more than 500,000 man-hours of quality training in finance.


Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to and we will rectify it.

Popular Blogs: Whatsapp Revenue Model | CFA vs CPA | CMA vs CPA | ACCA vs CPA | CFA vs FRM

Post ID = 71408