Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: unhide rows

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Christy
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello!
    I hid rows 1 through 6 and now I can't unhide them. "Help" tells me to select rows on either side of the hidden rows, of course there isn't a row before row 1 to select. Is there any way to unhide these rows?
    Thanks so much!
    ~Christy

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Georgia USA
    Posts
    569
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    select the gray cell next to A and above 1 then unhide

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Christy
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I tried that, it doesn't work. Any other ideas?

  4. #4
    New Member
    Join Date
    Mar 2002
    Location
    Nanaimo, BC
    Posts
    49
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    click on the cell stated above to select the whole sheet then right click on the border between that cell and the one next to it and then click unhide (make sure you get the resize icon before you right click)

  5. #5
    New Member
    Join Date
    Feb 2002
    Location
    Christy
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Kwaring, I tried that with a new file and it worked, however, on my existing file it does not work. I cannot get the resize symbol until after row 7 or column A. uuuugh!!

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Las Vegas Nevada USA
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Press F5 and enter A1 then go to Format/Rows/Unhide

  7. #7
    New Member
    Join Date
    Feb 2002
    Location
    Christy
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks George, but that didn't work either.

  8. #8
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Christy, I suspect your rows aren't hidden at all, they just have a zero or very small row height.

    Try hitting F5 and type in:

    a1:a6

    Hit Format-Row-Height and type in 12.75 (the default row height)
    ~Anne Troy

  9. #9
    New Member
    Join Date
    Feb 2002
    Location
    Christy
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks everyone - I finally got it! I had to select the entire sheet, hide it, then unhide it-!!!
    Thanks so much for all your help!!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •