Forum Discussion
Unhide Rows doesn't work - Exxcel 365
Tengo el mismo problema y nada funciona. Aun peor, si oculto nuevas filas para probar, las filas no vuelven a mostrarse. He probado darle variar el alto, tomar un grupo mayor de filas. Inicio, celdas, formato mostrar. Guardé la hoia en un libro nuevo y heredó los mismos problemas. A estas alturas pienso en re instalar Office.
- hakeaeMar 19, 2021Copper Contributor
Same thing for me - hid some rows, then could not unhide.
I tried suggestions above re Ctrl+A then increasing row height, but didn't help.
I accidentally found a way to get them back by picking up the row height adjustment bar at the bottom of the last hidden row, if that makes sense, then pulling down to increase row height and voila there was one row. I have had to repeat this for every hidden row to get them all back again. Very tedious and fortunately I only had 25 rows not 200 ...
So is this how Hide works? just sets row height to zero? So how come doing the select all rows and entering 20 didn't apply to the zero rows??I wonder if it was relevant that I had the first row frozen, and the hide rows started at 2.