PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO SHOW THE FORMULA USED IN GOOGLE SHEETS ?

INTRODUCTION

We use a number of functions and formulas in our calculation sheets.

We create various reports in Google Sheets where we use a number of formulas. When we need to check our report, we need to check each and every formula by selecting the cell and then peeping the formula bar for the formula description.

But we have one more smart solution for all this.

Google Sheets provide us the facility to show all the formulas used in a report and then proof read the report and its calculations at a flashing speed.

In this article, we’d  learn the way to show the formulas in google sheets and how to proof read in seconds.

 

 

WHY TO SHOW THE FORMULAS USED IN GOOGLE SHEETS ?

 

There can be many reasons for which you may want to show the formulas used in google sheets.

Some of the probable reasons are as follows:

  • For proof reading a report. We can check the text , figures as well as the calculation used. Normally, we do this by guessing the cell containing the formula, selecting the cell and then checking it in the formula bar. but we can do that easily if all the formulas in the complete list become visible at once.
  • For checking which cells of the sheet is containing a direct value and which cells are containing the formula.
  • Speed up proof reading and understanding the report easily.

WHERE TO FIND THE OPTION TO SHOW OR HIDE THE FORMULAS USED IN GOOGLE SHEETS

The option to show or hide the formulas can be found under the VIEW MENU > SHOW FORMULA.

The location is shown in the picture below.

EXAMPLE FOLLOWS AFTER THE PICTURE.

HOW TO SHOW OR HIDE THE FORMULA USED IN GOOGLE SHEETS
GO TO VIEW MENU >SHOW FORMULAS

EXAMPLE SHEET

We are sharing the screenshot of the example sheet on which we’ll be applying the method to show the formulas and then again hide the formulas to show the values instead.

HOW TO SHOW OR HIDE THE FORMULA USED IN GOOGLE SHEETS
STANDARD SHEET WITH SOME TEXT AND FORMULAS

STEPS TO SHOW THE FORMULAS USED IN GOOGLE SHEETS

FOLLOW THE STEPS TO SHOW FORMULAS IN GOOGLE SHEETS

  • Go to VIEW MENU and choose SHOW FORMULAS.
  • It’ll make all the cells in the sheet SHOW THE FORMULAS CONTAINED BY THEM.
 
  • The following picture shows the formulas used in a sheet.
HOW TO SHOW OR HIDE THE FORMULA USED IN GOOGLE SHEETS
SHEET SHOWING THE FORMULAS USED IN THE RESPECTIVE CELLS

STEPS TO hide THE FORMULAS USED IN GOOGLE SHEETS and start showing values

FOLLOW THE STEPS TO HIDE FORMULAS IN GOOGLE SHEETS

  • Go to VIEW MENU and choose SHOW FORMULAS.
  • It’ll make all the cells hide the formulas used in them and start showing the values of the formulas.
  • The following picture shows the values used in a sheet.
 
HOW TO SHOW OR HIDE THE FORMULA USED IN GOOGLE SHEETS
SHEET SHOWING THE VALUES INSTEAD OF FORMULAS [ STANDARD MODE ]

KEYBOARD SHORTCUT TO SHOW OR HIDE THE FORMULAS USED IN GOOGLE SHEETS

FOLLOW THE STEPS TO HIDE FORMULAS IN GOOGLE SHEETS

Simply press CTRL + `.
CTRL – CONTROL KEY IN THE BOTTOM LEFT CORNER OF KEYBOARD.
` – Key in the left of 1 number key i.e. First key in the second row from the above.
HOW TO ADJUST ROW WIDTH IN EXCEL
KEYBOARD SHORTCUT TO SHOW OR HIDE THE FORMUAS USED
HOW TO SHOW OR HIDE THE FORMULA USED IN GOOGLE SHEETS
KEYBOARD SHORTCUT TO SHOW OR HIDE THE FORMUAS USED

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

KINDLY SPEND FEW SECONDS HERE....

-We might be compensated for the visits or purchases you make by clicking the ads on this website .  They help us to keep bringing excellent quality articles for you.
-Click on the pictures if you can’t read. All of them are High Resolution .
-If you can’t find what you were looking for, kindly message in the chat box.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW