Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Location
    Franklin, Ohio, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhide Row Problem (Excel 2000 SR-1)

    I have a workbook that has hidden rows that I can't unhide using the normal format-column-unhide way. Any ideas?
    Attached Files Attached Files

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unhide Row Problem (Excel 2000 SR-1)

    The rows are not hidden, their height has been set to zero. Select rows 4 through 9 and then select Format/Row/Autofit and they should reappear.
    Legare Coleman

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Unhide Row Problem (Excel 2000 SR-1)

    The rows aren't really hidden, but have a very small row height of 0,75 points. Try the following:
    Click the row header of row 4.
    Shift+Click the row header of row 9.
    Change the row height by selecting Format/Row/Height... of by dragging the bottom edge of the row header of row 9.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Unhide Row Problem (Excel 2000 SR-1)

    Legare,

    The row height for rows 5 through 8 wasn't exactly 0; it showed as 0,75 points on my PC (Excel 97 SR2, WinNT 4.0). In fact, setting row height or column width to 0 is equivalent to hiding a row or column, AFAIK.

  5. #5
    New Lounger
    Join Date
    Jan 2002
    Location
    Franklin, Ohio, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unhide Row Problem (Excel 2000 SR-1)

    Thank you

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unhide Row Problem (Excel 2000 SR-1)

    Yes, I saw that, I just thought it might muddy the issue.
    Legare Coleman

Posting Permissions

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