{"id":5860,"date":"2023-05-17T07:37:00","date_gmt":"2023-05-17T05:37:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=5860"},"modified":"2023-10-31T13:58:25","modified_gmt":"2023-10-31T12:58:25","slug":"hide-or-unhide-excel-sheets","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/","title":{"rendered":"How to hide or unhide sheets in Excel files?"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-center\" id=\"h-how-to-hide-or-unhide-visible-or-hidden-worksheets-with-microsoft-excel\"><strong><em>How to hide or unhide visible or hidden worksheets with Microsoft Excel?<\/em><\/strong><\/h4>\n\n\n\n<p>It is possible to hide or unhide Excel sheets in a shared workbook to prevent any users changing data or settings. For example, if the Excel workbook is locked with a password, then the hidden data is protected from changes. With Microsoft Excel, how to unhide an Excel spreadsheet, i.e., make a hidden worksheet visible? There are two options, search in the Excel options at the top of the workbook or right click. Excel has been part of the Office 365 suite for some years.<\/p>\n\n\n\n<p><strong>Find the same Excel tutorial in video format on our channel, and you can subscribe here: <a href=\"https:\/\/youtube.com\/@Expert-Only?sub_confirmation=1\">Expert-Only Youtube channel<\/a>.<\/strong><\/p>\n\n\n\n<div style=\"text-align:center; display: block;\">\n<iframe loading=\"lazy\" width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/nywgrdd_gYw?si=wRoOyOsc1ZW6UOyA&amp;controls=0\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>\n<\/div>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/#1-show-hidden-excel-worksheets-using-the-excel-right-click-menu\" >1. Show hidden Excel worksheets using the Excel right-click menu<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/#2-unhide-the-hidden-spreadsheet-from-the-excel-format-menu\" >2. Unhide the hidden spreadsheet from the Excel Format menu<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/#3-unhide-all-hidden-sheets-at-the-same-time\" >3. Unhide all hidden sheets at the same time<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/#4-hide-one-excel-worksheet\" >4. Hide one Excel worksheet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/#5-hide-multiple-sheets-at-once\" >5. Hide multiple sheets at once<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-show-hidden-excel-worksheets-using-the-excel-right-click-menu\"><span class=\"ez-toc-section\" id=\"1-show-hidden-excel-worksheets-using-the-excel-right-click-menu\"><\/span>1. Show hidden Excel worksheets using the Excel right-click menu<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Firstly, Excel sheets appear as tabs in Excel. It is possible to display one or more hidden Excel worksheets in the easiest and fastest way using a very simple option. Just follow these two steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Right click<\/strong> on the name of the <strong>current Excel sheet<\/strong>.<\/li>\n\n\n\n<li>Click on <strong>Unhide<\/strong> and then <strong>choose the hidden worksheet<\/strong> to display.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"672\" height=\"490\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/excel_unhide_hidden_spredsheet_right_click.png\" alt=\"How to hide or unhide sheets in Excel files?\" class=\"wp-image-5861\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/excel_unhide_hidden_spredsheet_right_click.png 672w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/excel_unhide_hidden_spredsheet_right_click-300x219.png 300w\" sizes=\"auto, (max-width: 672px) 100vw, 672px\" \/><figcaption class=\"wp-element-caption\"><em>How to hide or unhide sheets in Excel files?<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-unhide-the-hidden-spreadsheet-from-the-excel-format-menu\"><span class=\"ez-toc-section\" id=\"2-unhide-the-hidden-spreadsheet-from-the-excel-format-menu\"><\/span>2. Unhide the hidden spreadsheet from the Excel Format menu<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Secondly, this solution is not as fast as the first one because you must click several times in the top menu of Excel. To use it follow these 3 steps:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>From the <strong>Home <\/strong>tab, choose <strong>Format <\/strong>menu on the left<\/li>\n\n\n\n<li>Then under Visibility select <strong>Hide and Unhide<\/strong><\/li>\n\n\n\n<li>Then click on <strong>Unhide Sheet<\/strong>, Choose now the sheet to be displayed in the list, only the hidden Excel worksheets appear.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"562\" height=\"695\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/excel_unhide_hidden_spreadsheet_format_menu.png\" alt=\"Manage Excel sheets visibility using the top menu\" class=\"wp-image-5867\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/excel_unhide_hidden_spreadsheet_format_menu.png 562w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/excel_unhide_hidden_spreadsheet_format_menu-243x300.png 243w\" sizes=\"auto, (max-width: 562px) 100vw, 562px\" \/><figcaption class=\"wp-element-caption\"><em>Manage Excel sheets visibility using the top menu<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-unhide-all-hidden-sheets-at-the-same-time\"><span class=\"ez-toc-section\" id=\"3-unhide-all-hidden-sheets-at-the-same-time\"><\/span>3. Unhide all hidden sheets at the same time<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To unhide multiple sheets at the same time, in both cases select all the sheets using one of the 2 options: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select all the sheets using the mouse cursor.<\/li>\n\n\n\n<li>Select all the worksheets one by one and maintain the CTRL option for multiple selection.<\/li>\n<\/ul>\n\n\n\n<p>Also, if this Excel tip is useful for you and you want to save even more time and efficiency with Excel, here is <a href=\"https:\/\/expert-only.com\/en\/excel\/the-best-excel-shortcuts-for-selection\/\"><strong>a selection of the best Excel shortcuts<\/strong><\/a> to manage spreadsheets.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-4-hide-one-excel-worksheet\"><span class=\"ez-toc-section\" id=\"4-hide-one-excel-worksheet\"><\/span>4. Hide one Excel worksheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To hide an Excel worksheet in a given file, simply use the two techniques above, but with the opposite option. For the first option using the right-click, follow these 2 steps: <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Right click<\/strong> on the name of the <strong>current Excel sheet<\/strong>.<\/li>\n\n\n\n<li>Click on <strong>Hide sheet<\/strong><\/li>\n<\/ol>\n\n\n\n<p>It is also possible to performe the same operation from the Home Excel menu:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>From the <strong>Home <\/strong>Excel tab, choose the <strong>Format <\/strong>menu<\/li>\n\n\n\n<li>Under Visibility select <strong>Hide and Unhide<\/strong><\/li>\n\n\n\n<li>Click on <strong>Hide Sheet<\/strong><\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-5-hide-multiple-sheets-at-once\"><span class=\"ez-toc-section\" id=\"5-hide-multiple-sheets-at-once\"><\/span>5. Hide multiple sheets at once<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>If you need to hide multiple Excel sheets in one time, again multiple solutions are available, first solution, in two steps, using the right click contextual menu to manage visibility: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Right-click<\/strong> on one sheet name<\/li>\n\n\n\n<li>Chose the <strong>Select All Sheets<\/strong> option<\/li>\n<\/ul>\n\n\n\n<p>Note that it is impossible to hide all the sheets from one file at once. Excel displays this message if you try &#8220;A workbook must contain at least one visible worksheet.&#8221;<\/p>\n\n\n\n<p>The second solution changes only the way you select the multiple necessary sheets. <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Click on them one by one while maintaining the CTRL key<\/strong>.<\/li>\n\n\n\n<li>Then right-click and choose <strong>Hide<\/strong>.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-conclusion-on-how-to-manage-excel-worksheets-visibility\">Conclusion on how to manage Excel worksheets visibility<\/h3>\n\n\n\n<p>In conclusion, this article explains how to display or hide Excel sheets in a workbook. The counterpart of these options allows of course to hide a visible sheet. To go further, here is another Office tutorial on Excel tips on <a href=\"https:\/\/expert-only.com\/en\/excel\/split-date-and-time-in-excel\/\">how to split date and time columns with Excel<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"vOUKxwcvS7\"><a href=\"https:\/\/expert-only.com\/en\/excel\/split-date-and-time-in-excel\/\">How to split date and time in Excel into separate columns?<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;How to split date and time in Excel into separate columns?&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/excel\/split-date-and-time-in-excel\/embed\/#?secret=lFlcEczTDe#?secret=vOUKxwcvS7\" data-secret=\"vOUKxwcvS7\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p class=\"has-text-align-center\"><strong>Find the content helpful ? Share it on your social platforms to support us<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>How to hide or unhide visible or hidden worksheets with Microsoft Excel? It is possible to hide or unhide Excel sheets in a shared workbook to prevent any users changing data or settings. For example, if the Excel workbook <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/\" title=\"How to hide or unhide sheets in Excel files?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":5602,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[457],"tags":[],"class_list":{"0":"post-5860","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to hide or unhide sheets in Excel files? MS Office Tips<\/title>\n<meta name=\"description\" content=\"To hide or unhide an Excel sheets, two solutions are available for visibility, from the right-click menu or from the Excel ribbon.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to hide or unhide sheets in Excel files?\" \/>\n<meta property=\"og:description\" content=\"To hide or unhide an Excel sheets, two solutions are available for visibility, from the right-click menu or from the Excel ribbon.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-17T05:37:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-31T12:58:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/metal-white-coffee-cup-25CB1BEFD9A_1920x1080.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"How to hide or unhide sheets in Excel files?\",\"datePublished\":\"2023-05-17T05:37:00+00:00\",\"dateModified\":\"2023-10-31T12:58:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/\"},\"wordCount\":630,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/metal-white-coffee-cup-25CB1BEFD9A_1920x1080.jpeg\",\"articleSection\":[\"Excel Tips\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/\",\"url\":\"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/\",\"name\":\"How to hide or unhide sheets in Excel files? MS Office Tips\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/metal-white-coffee-cup-25CB1BEFD9A_1920x1080.jpeg\",\"datePublished\":\"2023-05-17T05:37:00+00:00\",\"dateModified\":\"2023-10-31T12:58:25+00:00\",\"description\":\"To hide or unhide an Excel sheets, two solutions are available for visibility, from the right-click menu or from the Excel ribbon.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/metal-white-coffee-cup-25CB1BEFD9A_1920x1080.jpeg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/metal-white-coffee-cup-25CB1BEFD9A_1920x1080.jpeg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to hide or unhide sheets in Excel files?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to hide or unhide sheets in Excel files? MS Office Tips","description":"To hide or unhide an Excel sheets, two solutions are available for visibility, from the right-click menu or from the Excel ribbon.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/","og_locale":"en_US","og_type":"article","og_title":"How to hide or unhide sheets in Excel files?","og_description":"To hide or unhide an Excel sheets, two solutions are available for visibility, from the right-click menu or from the Excel ribbon.","og_url":"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-05-17T05:37:00+00:00","article_modified_time":"2023-10-31T12:58:25+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/metal-white-coffee-cup-25CB1BEFD9A_1920x1080.jpeg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"How to hide or unhide sheets in Excel files?","datePublished":"2023-05-17T05:37:00+00:00","dateModified":"2023-10-31T12:58:25+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/"},"wordCount":630,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/metal-white-coffee-cup-25CB1BEFD9A_1920x1080.jpeg","articleSection":["Excel Tips"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/","url":"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/","name":"How to hide or unhide sheets in Excel files? MS Office Tips","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/metal-white-coffee-cup-25CB1BEFD9A_1920x1080.jpeg","datePublished":"2023-05-17T05:37:00+00:00","dateModified":"2023-10-31T12:58:25+00:00","description":"To hide or unhide an Excel sheets, two solutions are available for visibility, from the right-click menu or from the Excel ribbon.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/metal-white-coffee-cup-25CB1BEFD9A_1920x1080.jpeg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/metal-white-coffee-cup-25CB1BEFD9A_1920x1080.jpeg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/excel\/hide-or-unhide-excel-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"How to hide or unhide sheets in Excel files?"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/5860","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=5860"}],"version-history":[{"count":3,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/5860\/revisions"}],"predecessor-version":[{"id":27882,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/5860\/revisions\/27882"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/5602"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=5860"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=5860"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=5860"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}