[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
One of the most common issues among Excel users is finding a reference to a sheet that doesn\u2019t seem to exist. Although you may quickly assume that the reference or formula is wrong, the solution could be as simple as unhiding the tab or sheet that is hidden.<\/p>\n
In this article, you\u2019ll discover the three methods to effectively unhide Excel sheets. First, you\u2019ll learn how to unhide Excel sheets manually. Secondly, how to unhide all sheets at once using VBA. And third, how to unhide all sheets using Custom View. Finally, you’ll learn a quick way to find hidden sheets and how to protect them with a password.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”how-to-unhide-excel-sheets” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
If your worksheet contains only a few hidden sheets, then the quickest way is to unhide them by right-clicking on the tabs in Excel. Let\u2019s see how this can be done.<\/p>\n
1.<\/strong> Right-click on any tab and then select \u201cUnhide\u2026\u201d from the drop-down menu.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/unhide-sheets-in-excel-right-click-tab-menu.webp” alt=”How to unhide sheets in Excel \u2014 right-click menu on a sheet tab with the Unhide option” title_text=”Right-click menu on a sheet tab with the Unhide option” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Select the sheet to unhide and click “OK”. In Excel for Microsoft 365, you can hold Ctrl or Shift to select several sheets at once.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/unhide-sheets-in-excel-unhide-dialog.webp” alt=”Unhide sheets in Excel \u2014 Unhide dialog listing hidden sheets with one selected and the OK button” title_text=”Unhide dialog listing hidden sheets with one selected and the OK button” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now that you know how to unhide a worksheet in Excel manually, let\u2019s see quicker methods to achieve this in case you have various hidden worksheets.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-unhide-all-sheets-in-excel” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Depending on the size of data contained in Excel, it is common practice to hide the sheets that may be less important for instant viewing. However, unhiding each by right-clicking on each tab can become a little tedious. Let\u2019s see the two ways to unhide all sheets at once in Excel using VBA and Custom View.<\/p>\n The VBA (Visual Basic for Applications) functionality lets you quickly hide and unhide sheets. This is how to unhide sheets in Excel using VBA.<\/p>\n 1.<\/strong> Right-click on any tab and select \u201cView Code\u201d from the pop-up menu to launch the Visual Basic Editor.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/unhide-sheets-in-excel-vba-view-code.webp” alt=”Unhide sheets in Excel using VBA \u2014 right-click menu on a sheet tab with View Code” title_text=”Right-click menu on a sheet tab with View Code” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Go to View > Immediate Window.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/unhide-sheets-in-excel-vba-immediate-window.webp” alt=”Unhide sheets in Excel using VBA \u2014 Visual Basic Editor View menu with Immediate Window highlighted” title_text=”Visual Basic Editor View menu with Immediate Window highlighted” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Copy the following line of code and paste into the \u201cImmediate\u201d window.<\/p>\n 4.<\/strong> Then, press \u201cEnter\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/unhide-sheets-in-excel-vba-code-line.webp” alt=”Unhide sheets in Excel using VBA \u2014 Immediate window with the For Each Sheet line of code” title_text=”Immediate window with the For Each Sheet line of code” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 5.<\/strong> Go back to your Excel workbook, and you’ll see that all sheets are now displayed. This also unhides very hidden sheets, which a macro can hide so they don’t appear in the Unhide dialog.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/unhide-all-sheets-in-excel-all-tabs-visible.webp” alt=”Unhide all sheets in Excel \u2014 workbook with every sheet tab visible, Sheet1 to Sheet13″ title_text=”Workbook with every sheet tab visible, Sheet1 to Sheet13″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now, let\u2019s see how you can quickly unhide all sheets using an alternative method.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-unhide-sheets-in-excel-using-cust” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Like VBA, the \u201cCustom View\u201d functionality in Excel allows you to hide and unhide all sheets at once in Excel. However, to use this method to unhide sheets, you will first need to create a view with all sheets unhidden to be able to activate the unhidden view. Moreover, Custom Views is grayed out if any sheet in the workbook contains an Excel table.<\/p>\n 1.<\/strong> Go to View > Custom Views.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/unhide-sheets-in-excel-custom-views-button.webp” alt=”Unhide sheets in Excel with custom view \u2014 View tab with the Custom Views button” title_text=”View tab with the Custom Views button” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Click on \u201cAdd\u2026\u201d to access the \u201cAdd view\u201d dialog box.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/unhide-sheets-in-excel-custom-views-add.webp” alt=”Unhide sheets in Excel with custom view \u2014 empty Custom Views dialog with the Add button” title_text=”Empty Custom Views dialog with the Add button” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Name this view, and click \u201cOK\u201d to save.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/unhide-sheets-in-excel-add-view-dialog.webp” alt=”Unhide sheets in Excel with custom view \u2014 Add View dialog with a view name and include options” title_text=”Add View dialog with a view name and include options” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now you\u2019ve created the Custom View where all sheets are displayed, let\u2019s see how to access it to quickly unhide all sheets in Excel.<\/p>\n You can activate a Custom View anytime you want to unhide all sheets in Excel. Follow these steps to activate your Custom View.<\/p>\n 1.<\/strong> Repeat the first step from the previous section.<\/p>\n 2.<\/strong> Select the view you created earlier and click \u201cShow\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/unhide-sheets-in-excel-show-custom-view.webp” alt=”Unhide sheets in Excel with custom view \u2014 saved view selected in Custom Views with the Show button” title_text=”Saved view selected in Custom Views with the Show button” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n And that\u2019s it. All your sheets should now be visible.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-hide-sheets-in-excel-with-a-passw” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Excel has no option to put a password on a single hidden sheet. Instead, you protect the sheet to lock its cells, then protect the workbook structure so nobody can unhide your hidden sheets without the password. Follow these steps to protect an Excel sheet with a password.<\/p>\n 1.<\/strong> Right-click on the sheet you would like to hide with a password and select \u201cProtect Sheet\u201d from the pop-up menu.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/hide-sheets-in-excel-protect-sheet-menu.webp” alt=”Hide sheets in Excel with a password \u2014 right-click menu on a sheet tab with Protect Sheet” title_text=”Right-click menu on a sheet tab with Protect Sheet” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> In the \u201cPassword to unprotect sheet\u201d field, create your password. Tick any of the option boxes below to customize user restrictions. Once finished, click \u201cOK\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/hide-sheets-in-excel-protect-sheet-password.webp” alt=”Hide sheets in Excel with a password \u2014 Protect Sheet dialog with a password and permission checkboxes” title_text=”Protect Sheet dialog with a password and permission checkboxes” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Excel prompts you to enter the password again to confirm. Click \u201cOK\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/hide-sheets-in-excel-confirm-password.webp” alt=”Hide sheets in Excel with a password \u2014 Confirm Password dialog asking to reenter the password” title_text=”Confirm Password dialog asking to reenter the password” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> Right-click on the tab and you will see “Unprotect Sheet\u2026” in the menu. The sheet is now protected.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/hide-sheets-in-excel-unprotect-sheet-menu.webp” alt=”Hide sheets in Excel with a password \u2014 tab menu showing Unprotect Sheet with Unhide grayed out” title_text=”Tab menu showing Unprotect Sheet with Unhide grayed out” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Doing this will restrict other users from making any changes to the cells contained in that sheet unless they enter the password. It doesn’t stop them from hiding or unhiding sheets, though. To keep a sheet hidden, right-click its tab and select “Hide”. Then go to Review > Protect Workbook, keep “Structure” checked, and enter a password. The Hide and Unhide options stay grayed out until someone enters that password. For more options, see how to protect an Excel workbook from editing<\/a>.<\/p>\n [\/et_pb_text][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Learning how to hide and unhide sheets in Excel using VBA or Custom View is a great way to save time and boost productivity, no matter the size of your data.<\/p>\n In this article, you have learned three ways to unhide Excel sheets, which can also be helpful in case you want to hide them again later. You have seen how to unhide them individually and in bulk using VBA or Custom View. You have also learned to unhide every sheet, very hidden ones included, with a single line of code, and how to protect them with a password.<\/p>\n If you would like to explore further ways to collaborate in Excel without losing control of your data, check out the following articles:<\/p>\n If some columns are hidden too, see how to unhide columns in Excel<\/a>. Working in Google Sheets instead? Here’s how to unhide sheets in Google Sheets<\/a>. And if your hidden sheets hold data you copy in from other files, Sheetgo’s AI automations<\/a> can bring that data in for you and keep it up to date.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Aprenda a reexibir planilhas no Excel uma de cada vez ou todas de uma vez com VBA ou modos de exibi\u00e7\u00e3o personalizados, e a manter as planilhas ocultas bloqueadas com senha.<\/p>","protected":false},"author":2,"featured_media":266131,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[],"class_list":["post-266116","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/266116","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=266116"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/266116\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/266131"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=266116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=266116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=266116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}How to unhide all sheets in Excel?<\/h2>\n
How to unhide sheets in Excel using VBA?<\/h3>\n
For Each Sheet In ThisWorkbook.Sheets: Sheet.Visible = True: Next Sheet<\/code><\/p>\nHow to unhide sheets in Excel using custom view?<\/h2>\n
How to create a custom view for unhidden sheets in Excel?<\/h3>\n
How to activate a custom view to unhide sheets in Excel?<\/h3>\n
How to hide sheets in Excel with a password?<\/h2>\n
Conclusion<\/h2>\n
\n