How to hide rows in excel shortcut

Answer

Hiding rows in Excel allows you to temporarily remove them from view without deleting any data. This is useful when working with large datasets or creating cleaner reports.

Keyboard Shortcut to Hide Rows

1. Windows:
   Select the row(s) you want to hide. Press Ctrl + 9.
   This instantly hides the selected row(s) from view.

2. Mac:
   Select the row(s) you want to hide. Press Command + 9.
   The selected rows will be hidden immediately.

Step-by-Step Instructions

1. Click on the row number(s) on the left side of the spreadsheet to select the rows.

2. Use the keyboard shortcut (Ctrl + 9 for Windows, Command + 9 for Mac).

3. Hidden rows are not deleted; they can be unhidden later.

How to Unhide Rows

1. Select the rows around the hidden row(s). For example, if row 5 is hidden, select rows 4 and 6.

2. Windows: Press Ctrl + Shift + 9.

3. Mac: Press Command + Shift + 9.

Notes and Tips

• Hidden rows do not affect formulas. SUM, AVERAGE, or other calculations still include hidden rows unless you use functions that ignore them, such as SUBTOTAL.

• To hide multiple non-adjacent rows, hold Ctrl while selecting row numbers, then use the shortcut.

• Hiding rows is often faster than deleting them when working on dynamic reports or filtered datasets.

This method works in all modern versions of Excel, including Excel 2016, 2019, and 365.

Yes · 0 No · 0 Add Comment · 0

Add ·

Report