How to hide multiple rows in excel

Answer

To hide multiple rows in Excel, follow these steps:

1. Select the rows you want to hide.

   • Click the row number of the first row.

   • Hold down Shift and click the row number of the last row in the range. This selects all rows in between.

2. Use the right-click menu.

   • Right-click on any selected row number.

   • Click Hide from the context menu.

3. Use the Ribbon.

   • Go to the Home tab.

   • In the Cells group, click Format → Hide & Unhide → Hide Rows.

4. Use a keyboard shortcut.

   • After selecting the rows, press Ctrl + 9 on Windows.

   • On Mac, press Command + 9.

5. Verify hidden rows.

   • Hidden rows are indicated by a missing row number sequence and a thicker line between visible rows.

Notes:

• Hidden rows do not delete data; formulas referencing hidden rows still calculate normally.

• You can hide non-contiguous rows by holding Ctrl (Windows) or Command (Mac) while selecting the row numbers.

• To unhide, select rows around the hidden ones, right-click, and choose Unhide, or use Ctrl + Shift + 9 (Windows) / Command + Shift + 9 (Mac).

Yes · 0 No · 0 Add Comment · 0

Add ·

Report