Show Hide Sheet Tabs in Excel

As I'm an excel macro developer, I'm receiving 4-5 excel files a day from my potential customers. One day I was wondering that there was no way to navigate through the sheets. I have checked if the sheets are hidden, no they are visible but can't navigate. Then I did a search on the google and found the solution.......!. Excel allows us to Hide sheet tabs. Let's see how.

• Click on Office Logo on excel 2007 or File on later versions
• Select Options from that submenu.
• Now you can see a new, popup window appears.
• Select Advanced from the left buttons.
• Scroll down to the Display Options for the Workbook section.
• Tic the option Show Sheet Tabs. (If you are going to hide the sheet tabs, remove the tic)
• Click OK.

Here is a picture about the Display options for workbook section. It shows how to show hide scroll bars on the excel.

Please make sure to have some kind of option like hyperlink or button to navigate through sheets if they are still needed to view.

You can watch the video here