Forum Discussion

Bryguy's avatar
Bryguy
Copper Contributor
Apr 11, 2020

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_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    Bryguy 

    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
  • mathetes's avatar
    mathetes
    Silver Contributor

    Bryguy 

     

    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.

Resources