{"id":8534,"date":"2016-12-14T02:08:31","date_gmt":"2016-12-14T02:08:31","guid":{"rendered":"http:\/\/www.top-password.com\/blog\/?p=8534"},"modified":"2016-12-14T02:08:31","modified_gmt":"2016-12-14T02:08:31","slug":"2-ways-to-hide-or-unhide-worksheet-in-excel","status":"publish","type":"post","link":"https:\/\/www.top-password.com\/blog\/2-ways-to-hide-or-unhide-worksheet-in-excel\/","title":{"rendered":"2 Ways to Hide or Unhide Worksheet in Excel 2016 \/ 2013 \/ 2010 \/ 2007"},"content":{"rendered":"

Is there a way to prevent others from viewing a sheet in an Excel workbook? If you don’t want people to change data or formula in a cell, you can hide the sheet. But this shouldn’t be used as a security measure. In this tutorial we’ll show you 2 ways to hide \/ unhide worksheet in Excel 2016 \/ 2013 \/ 2010 \/ 2007.<\/p>\n

Note:<\/strong> Excel doesn’t let you hide all sheets in a workbook. At least one has to be displayed.<\/em><\/p>\n

Method 1: Hide\/Unhide Excel Worksheet with GUI<\/strong><\/p>\n

    \n
  1. Right-click on the worksheet you want to hide, select Hide<\/strong> from the pop-up menu. Your worksheet will no longer be visible, however, the data contained in a hidden worksheet can still be referenced on other worksheets.\n

    \"hide-sheet\"<\/p>\n<\/li>\n

  2. To unhide a worksheet, just right-click on any visible worksheet and select Unhide<\/strong>.\n

    \"unhide-sheet\"<\/p>\n<\/li>\n

  3. In the Unhide dialog box, you can see all of the currently hidden sheets in the list box. Select a sheet you want to unhide and click OK<\/strong>.\n

    \"excel-hidden-sheets\"<\/p>\n<\/li>\n<\/ol>\n

    Method 2: Hide\/Unhide Excel Worksheet with VBA<\/strong><\/p>\n

    Excel has a more secure setting known as “Very Hidden”. A very hidden worksheet can’t be unhidden using the Excel user interface because it doesn’t appear in the Unhide dialog box. Here’s how to hide \/ unhide a worksheet with VBA editor:<\/p>\n

      \n
    1. To open the VBA editor, press the Alt<\/strong>+F11<\/strong> keyboard shortcut, or right-click on any worksheet and select View Code<\/strong>.\n

      \"excel-view-code\"<\/p>\n<\/li>\n

    2. From the Project<\/strong> window in the upper left pane, you can see all hidden and visible sheets in your workbook. Select a sheet you want to hide.<\/li>\n
    3. In the lower left pane, you can see all properties of your selected worksheet. In the Visible<\/strong> drop-down list, select xlSheetVeryHidden<\/strong>.\n

      \"xlSheetVeryHidden\"<\/p>\n<\/li>\n

    4. Close the VBA editor. Your worksheet will no longer be visible. When the Very Hidden attribute is set on a worksheet, the Hide<\/strong> option is greyed out.\n

      \"excel-unhide-greyed\"<\/p>\n<\/li>\n

    5. Very hidden sheets can only be made visible through the VBA editor. If you want to unhide a very hidden sheet, open the VBA editor and change the Visible<\/strong> attribute back to xlSheetVisible<\/strong>.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

      Is there a way to prevent others from viewing a sheet in an Excel workbook? If you don’t want people to change data or formula in a cell, you can hide the sheet. But this shouldn’t be used as a security measure. In this tutorial we’ll show you 2 ways to hide \/ unhide worksheet […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,10],"tags":[3177,3178,3179,3180],"class_list":["post-8534","post","type-post","status-publish","format-standard","hentry","category-others","category-tips-tricks","tag-hide-sheets-in-excel-vba","tag-hide-worksheet-in-excel","tag-unhide-excel-worksheet","tag-unhide-sheets-in-excel"],"_links":{"self":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts\/8534","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/comments?post=8534"}],"version-history":[{"count":2,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts\/8534\/revisions"}],"predecessor-version":[{"id":8542,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts\/8534\/revisions\/8542"}],"wp:attachment":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/media?parent=8534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/categories?post=8534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/tags?post=8534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}