Excel shortcuts

Unhide All Rows in Excel Shortcut

If you've ever hidden rows in an Excel spreadsheet only to find that you can't unhide them using the usual methods, don't despair - there's a shortcut that will unhide all rows in one go.

To unhide all rows in an Excel spreadsheet, simply hold down the Ctrl key and press the 9 key. All rows in the spreadsheet will be unhidden instantly.

If you only want to unhide a few rows, you can use the Ctrl key and the row number keys to unhide individual rows. For example, Ctrl+6 will unhide row 6. You can also use this method to unhide multiple rows - just hold down the Ctrl key and press the row number keys for the rows you want to unhide.

If you've hidden multiple rows and want to unhide them all at once, you can use the Ctrl+Shift+9 shortcut. This will unhide all rows between the row you have selected and the last row in the spreadsheet.

If you want to unhide all rows in a selection of cells, you can use the Ctrl+A shortcut to select all cells in the spreadsheet, then use the Ctrl+9 shortcut to unhide all rows.

You can also use the Ctrl+Shift+9 shortcut to unhide all rows in a selection of cells. This will unhide all rows between the first and last cell in the selection.

If you've hidden multiple rows and want to unhide them all at once, you can use the Ctrl+A shortcut to select all cells in the spreadsheet, then use the Ctrl+Shift+9 shortcut to unhide all rows between the first and last cell in the selection.

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.