SOLVED

Hide Rows

Copper Contributor

Hello. I am working on a spreadsheet that was developed by an inexperienced Excel user. This user has hidden many rows throughout the spreadsheet. I cannot unhide them using FORMAT - VISIBLITY - HIDE/UNHIDE - UNHIDE ROWS. Any thoughts?

Thank you.

2 Replies

@MJDRA 

Activate the Data tab of the ribbon. Is the Filter button in the Sort & Filter group highlighted? If so, click that button.

 

If that doesn't help:

Click the button in the upper left corner, at the intersection of the row numbers and column letters. This will select the entire sheet.

Set the row height to a reasonable value, e.g. 15 points.

best response confirmed by MJDRA (Copper Contributor)
Solution

@Hans Vogelaar 

Thank You Hans. As it turns out, it was one of many column filters that was active. All good now!

 

 

1 best response

Accepted Solutions
best response confirmed by MJDRA (Copper Contributor)
Solution

@Hans Vogelaar 

Thank You Hans. As it turns out, it was one of many column filters that was active. All good now!

 

 

View solution in original post