Notta
Showcase

back to gallery

how to unhide all rows in excel

5 steps
1

Select All Rows

Click on the triangle in the top-left corner of the worksheet to select all rows and columns. This triangle is located at the intersection of the row numbers and column letters.

2

Right-Click to Access Menu

With all rows selected, right-click anywhere on the selected area. This will open a context menu with various options.

3

Choose 'Unhide'

From the context menu, click on **'Unhide'**. This action will unhide all hidden rows in the entire worksheet.

4

Check for Hidden Rows

Scroll through your worksheet to ensure all previously hidden rows are now visible. If some rows remain hidden, you may need to repeat the process for specific row selections.

5

Save Your Changes

After confirming that all rows are unhidden, remember to save your workbook by clicking on **File** > **Save** or using the shortcut **Ctrl + S**.

Documents you might like

lighting effect

Start creating your guide online

Automate guide creations and save your time into things that matter.

Notta
Showcase
Copyright © 2024 Notta. All Rights Reserved.