Excel shortcuts

How to hide rows in Excel using a keyboard shortcut

Hiding rows in Excel can be a useful way to make your spreadsheet less cluttered and more organized. If you have a lot of data in your spreadsheet, you may want to hide some of the rows so that you can focus on the data that you need. Hiding rows can also be helpful if you want to print your spreadsheet and you don't want certain rows to be printed.

There are a few different ways that you can hide rows in Excel. One way is to manually select the rows that you want to hide and then right-click and select "Hide". Another way is to use a keyboard shortcut.

To hide rows using a keyboard shortcut, first select the rows that you want to hide. Then, hold down the "Ctrl" key on your keyboard and press the "9" key. This will hide the selected rows.

If you want to unhide the rows, you can use the same keyboard shortcut. Just hold down the "Ctrl" key and press the "9" key again. This will unhide any hidden rows in your spreadsheet.

Hiding rows can be a helpful way to make your Excel spreadsheet less cluttered and more organized. Using a keyboard shortcut to hide rows is a quick and easy way to do this.

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.