How to unhide all rows in excel quickly?

[zerofine]

Hello, I have multiple hidden rows in Excel and it’s hard to find them manually. I want to unhide everything at once. What is the easiest way?

 

[royjasika]

To quickly unhide all rows in Microsoft Excel, select the entire sheet by clicking the top-left corner or pressing Ctrl + A. Then right-click any row number and choose “Unhide.” Alternatively, go to the Home tab, click Format, select Hide & Unhide, and choose “Unhide Rows” to restore all hidden rows instantly.