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

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.

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.

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.

STEPS TO SHOW/HIDE FORMULA BAR IN GOOGLE SHEETS