View original (French)

Show all hidden rows in Excel.

Solved
livlarsen Posted messages 5 Status Member -  
 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

1 answer

  1.
    tchernosplif Posted messages 714 Status Member 249
     
    select all cells (small square at the top left)
    right click (anywhere except on the small square!!!)
    show
    62
    1. 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...
      20
    2. Fafa
       
      IMPORTANT INFORMATION: For this to work, there must be NO FILTER on the table data (filter selection menu activated). Office 2011 for MacOS.
      17