Excel Guides

Hiding and Unhiding Rows in Excel

There are a few different ways to hide and unhide rows in Excel. One way is to use the Hide and Unhide options in the Format menu. To hide a row, select the row you want to hide and then click on the Hide option in the Format menu. To unhide a row, select the row where you want the hidden row to appear and then click on the Unhide option in the Format menu.

Ctrl+9. To unhide a row, select the row where you want the hidden row to appear and then press Ctrl+Shift+9. You can also use these keyboard shortcuts to hide and unhide multiple rows at once.

  • If you're working with very large sheets, it may be easier to use the Group feature instead of hiding rows.
  • To group rows, select the rows you want to group and then click on the "Group"" button in the "Data" tab. You can also use keyboard shortcuts to group rows: press Ctrl+Shift+G. To ungroup rows, select the rows you want to ungroup and then click on the "Ungroup" button in the "Data" tab.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.