Hide and Seek – Formula Bar, Column and Row Headers

Have you ever experienced a shocking moment like this in #Excel?

Excel Tip - Display the formula bar and column row headers

We are so getting used to see the formula bar, Column and Row headers that we take it for granted.  They should always be there for me…. aren’t they?

What’s wrong with my Excel worksheet? 😨

No worry.  It’s just a setting under the View tab on the ribbon.

Make sure you have the “Formula Bar” and “Headings” checked.  As simple as this! 😉

Excel Tip - Display the formula bar and column row headers2

Advertisement

About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged , , , . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.