![]() ![]() ![]() If you don’t see any sheet tab in the workbook, it’s most likely because of the setting in the Excel Options dialog box that needs to be changed.Īnd in case you see some sheet tab names but some are missing, then you need to check if some of the sheets have been hidden by the user or if they are hidden because of a large scroll bar. Scroll down to the ‘Display Options for this Workbook’ section. In the ‘Options’ dialog box that opens, click on the Advanced option. So these are some of the ways you can use to fix the issue when the sheet tabs are missing and not showing in Excel. Below are the steps to restore the visibility of the tabs in Excel: Click the File tab. In such a case, you can use the navigation icons (which are at the left of the first sheet tab) to make those sheet tabs visible. In case you have a large workbook with a lot of sheets, even if you minimize the scrollbar, some sheet tabs would still be hidden. This is because of a large scrollbar that hides those tab names. Tabs are Hidden Because of the Scroll BarĪnother reason your tabs may be missing could be because of a large scroll bar that hides the tabs.Īnd it has a simple fix – resize the scroll bar to make all other tabs visible.īelow I have a screenshot of an Excel workbook where I have 8 sheets but only three sheet tabs are visible. It’s easy and it will only take a couple of clicks. You can read my tutorial here where I show you how to unhide those sheets that have been ‘very hidden’. Then how do you unhide these ‘very hidden’ sheets? Well, there is a way in Excel to hide a sheet in such a way that its name doesn’t show up in the Unhide dialog box. ![]() This would select all the sheets on which you click and then you can unhide all these with one click.īut what if you do not see the tab name in the names listed in the Unhide dialog box? To do this, hold the Control key (or Command key if using Mac) and then click on the Sheet names that you want to unhide. In case you want to unhide multiple sheets, you can select them in one go in the ‘Unhide’ dialog box. The above steps would unhide the selected sheet, and it would reappear as a tab in your workbook. In case there are no hidden sheets in the workbook, this option will be grayed out Right-click on any of the existing sheet tab name.When a worksheet is hidden in Excel, it continues to exist as a part of the Excel workbook, but you don’t see that sheet tab name along with other sheet tabs.Īnd this has a really simple solution – you need to unhide the sheets.īelow are the steps to unhide one or more sheets in Excel: The most likely reason that you cannot see some of the tabs in the workbook is that they have been hidden by the user. In this section, I have some solutions when only some of the tabs are missing and some are visible. Sometimes, you may be able to see some of the tabs in the workbook, while some others may be missing. Note that this setting is workbook specific – which means that in case you enable this setting in one of the workbooks, it would only make the tabs reappear in that specific workbook When Some of the Sheet Tabs are Missing The above change would ensure that all the available sheet tabs in the workbook become visible (unless the user has specifically hidden some of the worksheets) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |