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, GRIDLINES OR HEADINGS IN EXCEL?

INTRODUCTION

The options to hide the gridlines, formula bar and headings (column name and row number) gives us a flexibility to show or hide the same as per requirement.

BUTTON LOCATION FOR SHOW/HIDE IN EXCEL

show or hide gridlines in excel
SHOW/HIDE BUTTON

STEPS TO SHOW/HIDE IN EXCEL

GRID LINES-When checked will show the grid lines in Excel.

FORMULA BAR– When Checked FORMULA BAR ( the space where we put the formula) will be shown.

HEADINGS– When Checked HEADINGS (Row numbers and Column Names) will be shown.

UNCHECK ALL FOR HIDING ALL THE GRIDLINES, FORMULA BAR AND HEADINGS.

 

 

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

gyankosh060309@gmail.com

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: