Wednesday, December 13, 2017

How to unhide rows in an Excel sheet.

The hidden rows are kinda represented with two lines tightly close together as shown here. If you bring the cursor over the two lines and it takes the shape seen here of arrows emerging from two lines in lieu of just one line and you line up to bottommost line in the cursor with the bottommost line in the representation of the collapsed rows, then a click will unhide a row, the row adjacent to the unhidden row beneath the two line representation of collapsed rows. If you don't want to unhide oneseys and twoseys like this by going click-click-click you may select the two rows around the hidden rows and then right-click in one of them and pick the option for: "Unhide"

No comments:

Post a Comment