MS Excel Question re: hidden cells

Discussion in 'Computers' started by McPaul, Jun 20, 2006.

  1. McPaul

    McPaul Screenwriter

    Joined:
    Apr 1, 1999
    Messages:
    1,795
    Likes Received:
    50
    Location:
    Vancouver
    Real Name:
    Paul M
    I have a spreadsheet with some hidden cells on it.

    on the FAR left column, the numbering of the rows goes 1,2,3,4,18,19,20,21, 89, 90, etc...

    I have tried to UNhide these cells but for some reason it's not working correctly. I hilight all of the cells in the 'row number column', right click, select unhide, but it does nothing. I have even tried Ctrl-A, right click, unhide isn't listed as an option. I've tried right clicking at the VERY top left of the spreadsheet (before cell A!), and unhide does nothing.

    I've tried searching help, but I find MS help to be completely useless...

    what do I do? is there some kind of master unhide function to show absolutely ALL cells? and I KNOW there are cells hidden, because the spreadsheet (from view) is practically blank.

    Stupid question I know, but Thanks for your help.
     
  2. Bryan X

    Bryan X Producer

    Joined:
    Feb 10, 2003
    Messages:
    3,469
    Likes Received:
    3
    Try highlighting the range of rows which include the 'hidden' ones by dragging down along the left side where the row numbers are. Once you've highlighted them all, right click in the highlighted area and then click on 'Row Height' and set that number to 12.75.

    I'm guessing your rows aren't really hidden but just have a very small row height so they appear as though they are hidden.
     
  3. McPaul

    McPaul Screenwriter

    Joined:
    Apr 1, 1999
    Messages:
    1,795
    Likes Received:
    50
    Location:
    Vancouver
    Real Name:
    Paul M
    Awesome, Bryan. Hope that helps, thanks for the information!

    (I was thinking they might be something other than hidden, as well, but wasn't sure what that could be.)
     

Share This Page