Excel shortcuts

How to unhide all rows in excel shortcut

If you're anything like me, you're always looking for ways to work more efficiently in Excel. One way to do this is to use keyboard shortcuts to perform common tasks. Today, I want to share with you a keyboard shortcut that can save you a lot of time when working with large worksheets.

The keyboard shortcut I'm talking about is the one that lets you unhide all rows in a worksheet with a single keystroke. To do this, simply press Ctrl+Shift+9 on your keyboard. That's it! All of the rows in your worksheet will be unhidden.

If you have a lot of rows hidden in your worksheet, this shortcut can save you a lot of time. Instead of having to unhide each row individually, you can now unhide them all with a single keystroke.

I hope you find this keyboard shortcut useful. If you know of any other keyboard shortcuts that can save time, please share them in the comments below.

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.