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

[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