Hide/Un-hide Rows

Keyboard Shortcut for Hiding & Unhiding Row/s

  1. To hide selected Row/s, select complete Row/s which we want to hide & press CTRL + 9 – see picture below.

    Hiding excel row

In fact, clicking on any cell (rather than the whole row), will also produce the same result, please give it a try.

  1. To unhide selected Row/s, select cells or rows containing hidden Row/s which we want to unhide & press CTRL+SHIFT+9 – see picture below.

unhiding excel row