{"id":262710,"date":"2024-03-13T20:06:52","date_gmt":"2024-03-13T19:06:52","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=262710"},"modified":"2026-11-09T15:33:31","modified_gmt":"2026-11-09T14:33:31","slug":"mostrar-columnas-ocultas-en-excel","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/es\/blog\/excel-features\/how-to-unhide-columns-in-excel\/","title":{"rendered":"C\u00f3mo ocultar y mostrar columnas y filas en Excel"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>The ability to hide columns or rows in your spreadsheet can be very useful in some situations. You can keep certain fields or records hidden out of sight, but still in your tables or formulas. However, when you\u2019re collaborating with others, hidden rows and columns can be an unwelcome surprise. Fortunately, there are also multiple ways to find and unhide hidden columns and rows in Microsoft Excel.<\/p>\n<p>In this guide, you will learn three different ways to hide columns or rows in Microsoft Excel: using the right-click or context menu, using the \u2018Format\u2019 menu, and using a keyboard shortcut. You will also learn how to use \u2018Go to Special\u2019 to find hidden columns or rows. Additionally, you will learn four different ways of unhiding all columns and rows at once. Finally, you will learn three different ways of unhiding the first column or row, as well as any other individual columns and rows.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-hide-columns-in-excel&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to hide columns in Excel?<\/h2>\n<p>Below, you have step-by-step instructions on three different methods of hiding columns in Excel.<\/p>\n<h3>Right-click menu<\/h3>\n<p>Select the column or columns you want to hide. If you want to hide multiple columns, select the first and then hold down the Ctrl or Cmd key while selecting the rest. Right-click on your selection to get the context menu and choose \u2018Hide\u2019.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/how-to-hide-columns-in-excel-right-click-hide.webp&#8221; alt=&#8221;How to hide columns in Excel \u2014 right-click menu on the selected email and product columns with Hide highlighted&#8221; title_text=&#8221;Right-click menu on the selected email and product columns with Hide highlighted&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/how-to-hide-columns-in-excel-columns-hidden.webp&#8221; alt=&#8221;How to hide columns in Excel \u2014 email and product columns hidden, with the column letters jumping from C to F&#8221; title_text=&#8221;Email and product columns hidden, with the column letters jumping from C to F&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Format menu<\/h3>\n<p>Select the column you want to hide. If you want to hide multiple columns, hold down Ctrl or Cmd after the first, then select the others. Go to Format &gt; Column &gt; Hide.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/how-to-hide-columns-in-excel-format-menu.webp&#8221; alt=&#8221;How to hide columns in Excel \u2014 Format menu open at Column with Hide highlighted&#8221; title_text=&#8221;Format menu open at Column with Hide highlighted&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/how-to-hide-columns-in-excel-format-menu-result.webp&#8221; alt=&#8221;How to hide columns in Excel \u2014 first_name and last_name columns hidden, with the letters jumping from A to D&#8221; title_text=&#8221;First_name and last_name columns hidden, with the letters jumping from A to D&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Keyboard shortcut<\/h3>\n<p>You can also use a keyboard shortcut to hide columns. Select the column or columns you want to hide, holding down Ctrl or Cmd if you want to select multiple non-adjacent columns.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/how-to-hide-columns-in-excel-shortcut-select.webp&#8221; alt=&#8221;How to hide columns in Excel \u2014 first_name and last_name columns selected before the keyboard shortcut&#8221; title_text=&#8221;First_name and last_name columns selected before the keyboard shortcut&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Press Ctrl\/Cmd + 0 to hide the selected columns.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/how-to-hide-columns-in-excel-shortcut-result.webp&#8221; alt=&#8221;How to hide columns in Excel \u2014 columns B and C hidden after the keyboard shortcut&#8221; title_text=&#8221;Columns B and C hidden after the keyboard shortcut&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;how-to-hide-rows-in-excel&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to hide rows in Excel?<\/h2>\n<p>Follow the steps below to hide rows in Microsoft Excel.<\/p>\n<h3>Right-click menu<\/h3>\n<p>Select the row or rows you want to hide. If you want to hide multiple rows, select the first and then hold down the Ctrl or Cmd key while selecting the rest. Right-click on your selection to get the context menu and choose \u2018Hide\u2019.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/hide-rows-in-excel-right-click-hide.webp&#8221; alt=&#8221;Hide rows in Excel \u2014 right-click menu on several selected rows with Hide highlighted&#8221; title_text=&#8221;Right-click menu on several selected rows with Hide highlighted&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>The selected rows are now hidden.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/hide-rows-in-excel-rows-hidden.webp&#8221; alt=&#8221;Hide rows in Excel \u2014 row numbers skipping where the selected rows are hidden&#8221; title_text=&#8221;Row numbers skipping where the selected rows are hidden&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Format menu<\/h3>\n<p>Select the row you want to hide. If you want to hide multiple rows, hold down Ctrl or Cmd after the first, then select the others. Go to Format &gt; Row &gt; Hide.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/hide-rows-in-excel-format-menu.webp&#8221; alt=&#8221;Hide rows in Excel \u2014 Format menu open at Row with Hide highlighted&#8221; title_text=&#8221;Format menu open at Row with Hide highlighted&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>That\u2019s it. The selected rows are hidden.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/hide-rows-in-excel-format-menu-result.webp&#8221; alt=&#8221;Hide rows in Excel \u2014 rows hidden after the Format menu, with gaps in the row numbers&#8221; title_text=&#8221;Rows hidden after the Format menu, with gaps in the row numbers&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Keyboard shortcut<\/h3>\n<p>You can also use a keyboard shortcut to hide rows. Select the row or rows you want to hide, holding down Ctrl or Cmd if you want to select multiple non-adjacent rows.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/hide-rows-in-excel-shortcut-select.webp&#8221; alt=&#8221;Hide rows in Excel \u2014 several non-adjacent rows selected before the keyboard shortcut&#8221; title_text=&#8221;Several non-adjacent rows selected before the keyboard shortcut&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Press Ctrl\/Cmd + 9 to hide the selected rows.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/hide-rows-in-excel-shortcut-result.webp&#8221; alt=&#8221;Hide rows in Excel \u2014 selected rows hidden after the keyboard shortcut&#8221; title_text=&#8221;Selected rows hidden after the keyboard shortcut&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;use-go-to-special-to-find-hidden-columns&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Use Go to Special to find hidden columns or rows<\/h2>\n<p>You can also use the \u2018Go to Special\u2019 tool to find hidden columns and rows.<\/p>\n<p>Go to the \u2018Editing\u2019 area on the \u2018Home\u2019 tab and select &#8216;Go to Special&#8217;.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/find-hidden-columns-in-excel-go-to-special.webp&#8221; alt=&#8221;Find hidden columns in Excel \u2014 Find &#038; Select menu on the Home tab with Go to Special highlighted&#8221; title_text=&#8221;Find &#038; Select menu on the Home tab with Go to Special highlighted&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Choose \u2018Visible cells only\u2019 and click \u2018OK\u2019.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/find-hidden-columns-in-excel-visible-cells-only.webp&#8221; alt=&#8221;Find hidden columns in Excel \u2014 Go to Special dialog with Visible cells only selected&#8221; title_text=&#8221;Go to Special dialog with Visible cells only selected&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>As you can see below, white lines indicate the hidden columns and rows. In the next section, you have instructions on several methods you can use to unhide these columns and rows.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/find-hidden-columns-in-excel-visible-cells.webp&#8221; alt=&#8221;Find hidden columns in Excel \u2014 visible cells selected, with lines marking the hidden columns and rows&#8221; title_text=&#8221;Visible cells selected, with lines marking the hidden columns and rows&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;how-to-unhide-or-show-hidden-columns-and&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to unhide or show hidden columns and rows in Excel?<\/h2>\n<p>Below, you have instructions on four different methods you can use to unhide all columns and rows in your sheet. After that, you have instructions on three different ways of unhiding the first column or row, as well as any other columns and rows.<\/p>\n<h3>Unhide all rows &amp; columns<\/h3>\n<p>The first step is the same for all four methods: select the entire sheet by clicking on the intersection between the row numbers and the column letters.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/how-to-unhide-columns-in-excel-select-all.webp&#8221; alt=&#8221;How to unhide columns in Excel \u2014 Click here callout on the corner between the row numbers and column letters&#8221; title_text=&#8221;Click here callout on the corner between the row numbers and column letters&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>After selecting the sheet, you can use any of the four methods below to unhide all columns and rows in your sheet.<\/p>\n<h4>Right-click menu<\/h4>\n<p>After selecting the sheet, right-click to see the context menu. Right-click on the column letters to unhide columns, or right-click on the row numbers to unhide rows. Select \u2018Unhide\u2019.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/how-to-unhide-columns-in-excel-right-click-unhide.webp&#8221; alt=&#8221;How to unhide columns in Excel \u2014 right-click menu on the column letters with Unhide highlighted&#8221; title_text=&#8221;Right-click menu on the column letters with Unhide highlighted&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Any hidden columns are visible now.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/how-to-unhide-columns-in-excel-all-columns-visible.webp&#8221; alt=&#8221;How to unhide columns in Excel \u2014 email and product columns visible again across the sheet&#8221; title_text=&#8221;Email and product columns visible again across the sheet&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Format menu<\/h4>\n<p>After selecting the sheet, go to the \u2018Format\u2019 menu. You can choose Column &gt; Unhide and then Row &gt; Unhide to make all rows and columns visible.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/how-to-unhide-columns-in-excel-format-menu.webp&#8221; alt=&#8221;How to unhide columns in Excel \u2014 Format menu open at Column with the Hide and Unhide options&#8221; title_text=&#8221;Format menu open at Column with the Hide and Unhide options&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Resize all columns or rows<\/h4>\n<p>Finally, you can unhide all columns and rows by resizing them. Select the entire sheet as shown in the beginning of this section.<\/p>\n<p>Grab one of the lines dividing the column letters and adjust it to resize the column slightly.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/how-to-unhide-columns-in-excel-resize.png&#8221; alt=&#8221;How to unhide columns in Excel \u2014 Resize Columns or Rows to Unhide callout on the divider lines&#8221; title_text=&#8221;Resize Columns or Rows to Unhide callout on the divider lines&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Let\u2019s adjust the column width first. As soon as you let go, all columns will be visible.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/how-to-unhide-columns-in-excel-resize-result.webp&#8221; alt=&#8221;How to unhide columns in Excel \u2014 all columns visible after resizing, with the rows still hidden&#8221; title_text=&#8221;All columns visible after resizing, with the rows still hidden&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>To unhide rows, grab one of the lines dividing the row numbers and resize the row by dragging it down. All rows are now visible, too.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/unhide-rows-in-excel-resize-rows.png&#8221; alt=&#8221;Unhide rows in Excel \u2014 all rows and columns visible after resizing the rows&#8221; title_text=&#8221;All rows and columns visible after resizing the rows&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Keyboard shortcuts<\/h3>\n<p>As promised, there are two keyboard shortcuts you can use to unhide columns or rows.<\/p>\n<h4>Unhide rows only<\/h4>\n<p>After selecting the sheet, use the following shortcut to unhide all rows.<\/p>\n<ul>\n<li><strong>Windows:<\/strong> Ctrl + Shift + 9<\/li>\n<li><strong>Mac:<\/strong> Cmd + Shift + 9<\/li>\n<\/ul>\n<h4>Unhide columns only<\/h4>\n<p>With the whole sheet selected, use the shortcut below to unhide all columns.<\/p>\n<ul>\n<li><strong>Windows:<\/strong> Ctrl + Shift + 0<\/li>\n<li><strong>Mac:<\/strong> Cmd + Shift + 0<\/li>\n<\/ul>\n<h3>Unhide individual columns or rows<\/h3>\n<p>The first column or row can seem trickier to unhide, but it\u2019s actually very easy to do. Below, you have step-by-step instructions on three quick methods for unhiding individual columns or rows.<\/p>\n<h4>Click &amp; drag<\/h4>\n<p>Hover over the left side of the first visible column to see the icon with the double line with arrows. Click and drag it right to show the first column.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/how-to-unhide-first-column-in-excel-drag.webp&#8221; alt=&#8221;How to unhide the first column in Excel \u2014 column A dragged back into view at the left edge&#8221; title_text=&#8221;Column A dragged back into view at the left edge&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>To show the first row, hover over the top line of the first visible cell to see the icon with the double line and arrows. Click and drag down to show the first row.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/how-to-unhide-first-row-in-excel-drag.png&#8221; alt=&#8221;How to unhide the first row in Excel \u2014 header row dragged down from a thin line at the top&#8221; title_text=&#8221;Header row dragged down from a thin line at the top&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Right-click menu<\/h4>\n<p>Select the columns on either side of the hidden one and right-click. Choose \u2018Unhide\u2019. To show a row, select the rows above and below the one you want to unhide.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/unhide-columns-in-excel-right-click-adjacent.webp&#8221; alt=&#8221;Unhide columns in Excel \u2014 columns G and I selected around a hidden column with the right-click menu open&#8221; title_text=&#8221;Columns G and I selected around a hidden column with the right-click menu open&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/unhide-columns-in-excel-column-restored.webp&#8221; alt=&#8221;Unhide columns in Excel \u2014 date column visible again in column H between the selected columns&#8221; title_text=&#8221;Date column visible again in column H between the selected columns&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Format menu<\/h4>\n<p>Select the columns on either side of the hidden one and go to Format &gt; Column &gt; Unhide. To unhide a row, select the rows above and below it and go to Format &gt; Row &gt; Unhide.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/unhide-columns-in-excel-format-unhide.png&#8221; alt=&#8221;Unhide columns in Excel \u2014 Format menu open at Column with Unhide highlighted&#8221; title_text=&#8221;Format menu open at Column with Unhide highlighted&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/unhide-columns-in-excel-column-visible.png&#8221; alt=&#8221;Unhide columns in Excel \u2014 date column shown again in column H after Unhide&#8221; title_text=&#8221;Date column shown again in column H after Unhide&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;conclusion&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Conclusion<\/h2>\n<p>As you have seen, there are a lot of different ways to hide and unhide columns and rows in Microsoft Excel. You now know three different ways to hide columns or rows in Excel: the right-click or context menu, the \u2018Format\u2019 menu, and a keyboard shortcut. You also know how to use \u2018Go to Special\u2019 to find hidden columns and rows. Additionally, you know four ways to unhide all columns and rows at once, without having to worry about finding them. Finally, you know three ways to unhide individual columns and rows, including the first column and top row.<\/p>\n<p>To learn more about Microsoft Excel and Google Sheets, check out our guides on:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-unhide-excel-sheets\/\">How to unhide Excel sheets and how to hide sheets in Excel?<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-unhide-sheets-in-google-sheets\/\">How to hide and unhide tabs in Google Sheets<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/excel-features\/combine-multiple-columns-in-excel-into-one-column\/\">How to combine multiple Excel columns into one?<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/excel-features\/how-to-split-cells-in-excel\/\">How to split cells in Excel? 6 easy methods<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/excel-features\/how-to-lock-cells-in-excel\/\">How to lock cells in Excel? (cells, sheets &amp; formulas)<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/freeze-rows-columns-google-sheets\/\">How to freeze rows and columns in Google Sheets<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/excel-features\/pivot-table-in-excel\/\">How to create a pivot table in Excel<\/a><\/li>\n<\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Aprende a mostrar columnas ocultas en Excel y a ocultar columnas y filas con el men\u00fa contextual, el men\u00fa Formato y atajos de teclado.<\/p>","protected":false},"author":2,"featured_media":262739,"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":[51],"tags":[],"class_list":["post-262710","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-features"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/262710","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=262710"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/262710\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/262739"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=262710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=262710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=262710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}