Show all hidden rows in Excel.
Solved
livlarsen
Posted messages
5
Status
Membre
-
Mehdiiii -
Mehdiiii -
Hello,
I have hundreds of hidden rows in an Excel file and I'm trying to display them all. I've selected my sheet and right-clicked to unhide, but nothing happens. The only way I found is to go one row at a time... What should I do???
Thank you,
Liv
Configuration: Windows XP / Safari 534.3
I have hundreds of hidden rows in an Excel file and I'm trying to display them all. I've selected my sheet and right-clicked to unhide, but nothing happens. The only way I found is to go one row at a time... What should I do???
Thank you,
Liv
Configuration: Windows XP / Safari 534.3
1 answer
select all cells (small square at the top left)
right click (anywhere except on the small square!!!)
show
right click (anywhere except on the small square!!!)
show
Azraoth
I just almost pulled my hair out over the same problem (Excel 2003 SP3). No protection, no panes, no autofilters... unable to click "Show All"... and then the solution came: select all the rows ("CTRL A" or others) + position yourself on a separator/line break and bring up the infamous cursor with the double line + up and down arrow -> left click on the separator and it works... phew, 1500 lines with 900 hidden...
Fafa
IMPORTANT INFORMATION: For this to work, there must be NO FILTER on the table data (filter selection menu activated). Office 2011 for MacOS.