back to gallery
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.
With all rows selected, right-click anywhere on the selected area. This will open a context menu with various options.
From the context menu, click on **'Unhide'**. This action will unhide all hidden rows in the entire worksheet.
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.
After confirming that all rows are unhidden, remember to save your workbook by clicking on **File** > **Save** or using the shortcut **Ctrl + S**.