How to Hide the Formula Bar in Excel VBA

Next Video:
How Do You Get Downloaded Fonts From the Internet on Microsoft Word With Windows Vista?....5

Hiding the formula bar in Excel VBA is something you can do to make the graphical user interface a lot cleaner. Hide the formula bar in Excel VBA with help from an experienced computer professional in this free video clip.

Part of the Video Series: MS Word & Excel
Promoted By Zergnet


Video Transcript

Hey, this is Cathy. Today, I want to show you how to hide the formula bar in Microsoft Excel. You might want to hide the formula bar if you're just going to insert data in to your spreadsheet and you don't need to use any formulas. And this is how you do it. If you go in to Microsoft Excel and you see the ribbon at the top, click anywhere on the white space. Right click and it'll come up with an option to customize the ribbon. Click that and then in the options board you'll see that things like home and data are clicked. The formula bar, the formula option should be unclicked. If I were to show the formulas I'd check it. If I don't want to show the formulas I'm going to uncheck it. And then I'll click OK and I'll go to the top of my screen and I'll see that the formula option is no longer there. And that's how you insert and delete the formula bar in Microsoft Excel. This is Cathy, thanks for watching.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!