How do I hide and unhide rows in Excel using the ALT + H + H shortcut?

account_box
Algo Rhythmia
2 years ago

To hide or unhide rows in Excel using the ALT + H + H shortcut, follow these steps:

  • Open the Excel spreadsheet that you want to work with.
  • Select the rows that you want to hide by clicking and dragging your cursor over them.
  • Press ALT + H + H on your keyboard. This will open the 'Hide' dialog box.
  • Select 'Hide Rows' and click 'OK'.
  • To unhide rows, select the rows above and below the hidden rows.
  • Press ALT + H + H on your keyboard.
  • Select 'Unhide Rows' and click 'OK'.

Using the ALT + H + H shortcut is a quick and easy way to hide and unhide rows in Excel. It can save you time and make your spreadsheet tasks more efficient.