Forum Discussion
Bryguy
Apr 11, 2020Copper Contributor
trouble unhiding rows
when i control select - highlight immediately above and below several hidden rows, then click on unhide, it doesn't unhide them. when I try double-clicking on the faint line where the hidden rows are, and double click, that doesn't help either. any suggestions? this is my first post, ever.
- Riny_van_EekelenPlatinum Contributor
If neither of the suggested solutions works, I suspect that the rows are not only hidden but that they have been given (perhaps accidentally) a very small row height. Unhiding will change the status of the rows, but it will still not make them visible.
Try selecting all cells in the sheet (the triangle in the top left corner of the sheet) and set the row height to (for instance) 15.
- If you have multiple rows hidden and you want to unhide all of them at the same time, kindly select all the rows close to the hidden rows or you select all your data and press CTRL+SHIFT+9
- DogMommaCopper Contributor
Thank you ! this worked
- mathetesSilver Contributor
Somebody else posted a very similar question recently. Turned out that person had the Filter turned on, and though indeed rows were hidden, it was because they'd been filtered out. So "unhide" wasn't the needed resolution. It was to turn off "Filter" or select all in the Filter. Is that the case with you? If not, maybe you could post a copy of the file.