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

Contents

HOW TO SHOW OR HIDE FORMULA BAR AND GRIDLINES IN GOOGLE SHEETS ?

INTRODUCTION

All the spreadsheet applications consist of the cell which mark the separate small areas to hold any values or text.

The cells have their own importance as they clearly define the boundaries of the small working areas. But when we are designing any applications, with the help of VBA or some presentable

artistic forms , the gridlines [ The criss cross lines making up the cells ] become a nuisance and we want to hide them for a while.

We are lucky to have the options to hide or show the gridlines in google sheets as per our convenience

The options to hide the gridlines and formula bar gives us a flexibility to show or hide the same as per requirement.

 

In this small article, we’ll learn the way we can show or hide the gridlines and the formula bar in google sheets.

 

 

BUTTON LOCATION FOR SHOW/HIDE GRIDLINES IN GOOGLE SHEETS

 

 

The option for SHOWING/HIDING the gridlines is given the VIEW MENU.

The following picture shows the location of the option.

HOW TO SHOW OR HIDE GRIDLINES AND FORMULA BAR IN GOOGLE SHEETS
GO TO VIEW MENU >GRIDLINES

STEPS TO SHOW/HIDE GRIDLINES IN GOOGLE SHEETS

FOLLOW THE STEPS TO SHOW/ HIDE THE GRIDLINES IN GOOGLE SHEETS

  • Go to VIEW MENU and choose GRIDLINES.
  • If the GRIDLINES are visible, they’ll be hidden and if GRIDLINES are hidden , they’ll be shown.
  • It is kind of  a toggle button.
  • The following picture shows the gridlines hidden.
HOW TO SHOW OR HIDE GRIDLINES AND FORMULA BAR IN GOOGLE SHEETS
SHEET WITHOUT GRIDLINES

BUTTON LOCATION FOR SHOW/HIDE FORMULA BAR IN GOOGLE SHEETS

 

 

The button location for SHOW/HIDE the formula bar is present under the VIEW MENU > FORMULA BAR.

HOW TO SHOW OR HIDE GRIDLINES AND FORMULA BAR IN GOOGLE SHEETS
GO TO VIEW MENU AND CHOOSE FORMULA BAR TO SHOW OR HIDE FORMULA BAR

STEPS TO SHOW/HIDE FORMULA BAR IN GOOGLE SHEETS

FOLLOW THE STEPS TO SHOW/ HIDE THE GRIDLINES IN GOOGLE SHEETS

  • Go to VIEW MENU and choose FORMULA BAR.
  • If the FORMULA BAR is visible, it’ll be hidden and if the FORMULA BAR is hidden, it’ll appear.
  • It is kind of  a toggle button.
  • The following picture shows the formula bar hidden.
HOW TO SHOW OR HIDE GRIDLINES AND FORMULA BAR IN GOOGLE SHEETS
SHOW/HIDE BUTTON

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