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 doesnโ€™t work on Excel most of the time at current job...... ๐Ÿค” 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.