How to fix missing excel sheets tab toolbar

If ever you manage to lose your sheets tab bar at the bottom of your excel workbook, don’t stress this is NOT some form of black magic, odds are its just hidden.
STEP #1 Stop the panic attack!

Most of the time if not 99%(this is a made up figure) of the time your workbook inside excel is most likely just not maximized and therefore you cannot scroll down to the bottom of the workbook.

The easiest fix for this is selecting the workbook you want/need as there might be multiple open once in the same instance of your open excel application and hit the maximize button, for Microsoft Excel 2010 the shortcut key is 'Ctrl' + 'F10' & poof just like magic its back ;)


If however it’s still missing, check your options to see if this bar is set to 'visible' to do this in Microsoft Excel 2010 follow these steps.

• Click 'File' > 'Options'
• In the Excel Options window select the 'Advanced' tab and scroll down to the display section, check that the 'Show sheet tabs' is ticked.

The last thing that it could be is that you’re not supposed to see them and its hidden using a VBA macro of some sort or it is password protected and you chose to ignore the popup prompting you for it or you don’t have the password allowing you to edit the data sheets.