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
Copyright © 2024 Notta. All Rights Reserved.