To unhide a tab bar in Excel, click on File >> More >> Options. After this, go to an Advanced option which you can see in a left side panel. Now, scroll down & find Display options. Under Display options, ensure to check the box of ‘Show sheet tabs.’