【EXCEL】Easy Way! How to Unhide Hidden Rows in Bulk

Thank you for visiting. This is Masafukuro.

In this article, I will introduce a method to bulk unhide hidden rows at once.

Bulk Unhiding of Hidden Rows

Step.1

Select the boundary between hidden and visible rows

Step.2

Hover the cursor near the row numbers "5" and "100"

Step.3

Double-click with the vertical arrow symbols activated

Select the displayed rows "5th row" and "100th row".

Ｈｉｎｔ

To select rows:

Click on the row number "5".

Drag until the row number "100".

When you hover the cursor between row number "5" and row number "100", the arrow symbol changes to vertical arrows pointing up and down.

Double-clicking with the vertical arrow symbols activated will reveal the hidden rows from the "6th row" to the "99th row".

For related articles on "Functionality," please click here.

Thank you for reading until the end!