{"id":511790,"date":"2022-11-17T22:00:10","date_gmt":"2022-11-17T19:00:10","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-unhide-all-rows-in-excel\/"},"modified":"2022-11-17T22:00:10","modified_gmt":"2022-11-17T19:00:10","slug":"how-to-unhide-all-rows-in-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-unhide-all-rows-in-excel\/","title":{"rendered":"#How to Unhide All Rows in Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a296fafee7fe\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a296fafee7fe\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-unhide-all-rows-in-excel\/#%E2%80%9CHow_to_Unhide_All_Rows_in_Excel%E2%80%9D\" >&#8220;How to Unhide All Rows in Excel&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-unhide-all-rows-in-excel\/#How_to_Unhide_All_Rows_in_Excel_With_a_Shortcut\" >How to Unhide All Rows in Excel With a Shortcut<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-unhide-all-rows-in-excel\/#How_to_Unhide_All_Rows_and_Columns_in_Excel\" >How to Unhide All Rows and Columns in Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-unhide-all-rows-in-excel\/#How_to_Unhide_Specific_Rows_in_Excel\" >How to Unhide Specific Rows in Excel<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Unhide_All_Rows_in_Excel%E2%80%9D\"><\/span>&#8220;How to Unhide All Rows in Excel&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731027\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo.\" width=\"1200\" height=\"675\"\/><\/p>\n<p>First, select your entire worksheet using Ctrl+A (Windows) or Command+A (Mac). Ppress Ctrl+Shift+9, right-click a cell and choose &#8220;Unhide,&#8221; or select Format &gt; Hide &amp; Unhide &gt; Unhide Rows from the ribbon at the top to unhide all rows.<\/p>\n<p>Unhiding all the rows in a Microsoft Excel spreadsheet is as easy as pressing a keyboard shortcut or\u00a0using a button on the ribbon. We\u2019ll show you how.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Unhide_All_Rows_in_Excel_With_a_Shortcut\"><\/span>How to Unhide All Rows in Excel With a Shortcut<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To show hidden rows in your spreadsheet, <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/322260\/how-to-open-word-excel-or-powerpoint-in-safe-mode\/\">launch your spreadsheet with Microsoft Excel. Then, access the worksheet in which you have the hidden content.<\/p>\n<p>Select your entire worksheet by pressing Ctrl+A (Windows) or Command+A (Mac). Alternatively, click the \u201cSelect All\u201d button in the worksheet\u2019s top-left corner.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-845197\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/1-select-entire-worksheet-excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Choose &quot;Select All&quot; in the worksheet's top-left corner.\" width=\"521\" height=\"381\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>While your\u00a0worksheet is selected, unhide all rows by using this shortcut: Ctrl+Shift+9. Or, right-click a selected cell and choose \u201cUnhide\u201d in the menu.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Unhide_All_Rows_and_Columns_in_Excel\"><\/span>How to Unhide All Rows and Columns in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Alternatively, in Excel\u2019s \u201cHome\u201d tab in the ribbon, click the Format &gt; Hide &amp; Unhide &gt; Unhide Rows option. This also works for<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-845200\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/3-unhide-rows-columns-excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select Format &gt; Hide &amp; Unhide &gt; Unhide Rows or Unhide Columns.\" width=\"562\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Excel will make all your hidden rows visible again in your spreadsheet. You\u2019re all set.<\/p>\n<p><strong>RELATED:<\/strong> <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/757137\/how-to-hide-or-unhide-columns-in-microsoft-excel\/\"><strong><em>How to Hide or Unhide Columns in Microsoft Excel<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Unhide_Specific_Rows_in_Excel\"><\/span>How to Unhide Specific Rows in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To reveal only specific rows while keeping all other hidden items invisible, use the following method.<\/p>\n<p>To unhide a specific row, click <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/220829\/how-to-show-and-hide-row-and-column-headers-in-excel\/\">the header of the row that\u2019s above your hidden row. For instance, to unhide row <code>6<\/code> , click the header for row <code>5<\/code> .<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-845201\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/4-select-row-above-hidden-row.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the row that's above the hidden row.\" width=\"550\" height=\"383\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Now, press and hold down the Shift key on your keyboard and click the header of the row that\u2019s beneath your hidden row. In the above example, you\u2019ll click the header for row <code>7<\/code> (while the Shift key is held down).<\/p>\n<blockquote class=\"admonishment_note\"><p><strong>Note:<\/strong> You hold down Shift and click a row header because doing so selects all the rows between your clicked items. This selects your hidden content as well, which you\u2019ll unhide in the following step.<\/p><\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-845202\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/5-select-row-below-hidden-row.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Hold down Shift and select the row that's beneath the hidden row.\" width=\"569\" height=\"377\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Right-click the header of a selected row and from the open menu, choose \u201cUnhide.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-845203\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/6-unhide-specific-hidden-row.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select &quot;Unhide&quot; in the menu.\" width=\"538\" height=\"499\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And that\u2019s it. Excel has unhidden your selected content, and you can now work with it the way you want.<\/p>\n<p>Want to unhide all of your Excel columns too? Check out our guide.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>12 Basic Excel Functions Everybody Should Know<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/845189\/how-to-unhide-all-rows-in-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Unhide All Rows in Excel&#8221; First, select your entire worksheet using Ctrl+A (Windows) or Command+A (Mac). Ppress Ctrl+Shift+9, right-click a cell and choose &#8220;Unhide,&#8221; or select Format &gt; Hide &amp; Unhide &gt; Unhide Rows from the ribbon at the top to unhide all rows. Unhiding all the rows in a Microsoft Excel spreadsheet&#8230;<\/p>\n","protected":false},"author":1,"featured_media":511791,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-511790","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/511790","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=511790"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/511790\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/511791"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=511790"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=511790"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=511790"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}