Hide and Seek – Scroll Bars and Worksheet Tabs in #Excel

Did you encounter this?  All the worksheet tabs and scroll bars are gone in your Excel workbook!!!

Excel Tip - Hide and Seek Scroll bars and worksheet tabs

🎶🎶 Tell me… how am I supposed to work without you…🎶🎶

 

No worries!  They are not gone.  They are just hidden (by someone somehow 🤔).

Let’s get them back to work! 

Go to File –> Option

  1. Advanced
  2. Scroll down till you see “Display options for this workbook”
  3. Check the boxes
  4. OK

Excel Tip - Seek it

As simple as this!

 

Excel Tip - Hide and Seek Scroll bars and worksheet tabs_Finish

 

 

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 )

Google photo

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

Twitter picture

You are commenting using your Twitter 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.