Results 1 to 9 of 9
  1. #1
    4 Star Lounger
    Join Date
    Mar 2004
    Location
    Griffith, New South Wales, Australia
    Posts
    507
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can't see all rows (Win xp + Excel 2000)

    I have a spreadsheet where I cannot see the top 14 rows.

    My top row is #15. There are no hidden rows, there is no freeze on the worksheet, or anything else that I can see.

    If I do a search for specific data, the find is returned with data from the rows I cannot see, but I cannot arrow up to get to it.

    It's probably something simple, but I cant see it. Help?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Can't see all rows (Win xp + Excel 2000)

    Could you attach it (you can delete everything else)?

    Steve

  3. #3
    4 Star Lounger
    Join Date
    Mar 2004
    Location
    Griffith, New South Wales, Australia
    Posts
    507
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't see all rows (Win xp + Excel 2000)

    see attached

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Can't see all rows (Win xp + Excel 2000)

    You wer mistaken in your original post: The rows are hidden.

    Ctrl-a (to select all)
    format - row - unhide

    will display them

    Steve

  5. #5
    4 Star Lounger
    Join Date
    Mar 2004
    Location
    Griffith, New South Wales, Australia
    Posts
    507
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't see all rows (Win xp + Excel 2000)

    thank you. I knew it would be easy. It was the ctrl + a to select all that I could not get. When I tried highlighting all, by clicking the left hand corner, I didnt get the ooption to unhide.

    Thanks. it will make my weekend a bit easier

  6. #6
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't see all rows (Win xp + Excel 2000)

    You can unhide rows even if you do not remember the Ctrl + a trick. Click the left hand corner and then use the menu system Format/Row/Unhide. Or, you can use F5 to go to a cell in a hidden row and use the menu system Format/Row/Unhide (this only unhides the current row).

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  7. #7
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't see all rows (Win xp + Excel 2000)

    ... or mouse up the numbers of the rows up to and including the 'select all' square top left, then Format | Rows | Unhide

  8. #8
    Star Lounger
    Join Date
    Sep 2002
    Location
    Honolulu, Hawaii, USA
    Posts
    63
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Can't see all rows (Win xp + Excel 2000)

    Note that using the the menu command Format - Row - Unhide returns the row height of the selected cells' rows to their last setting that was greater than 0, and it only affects those rows where row height = 0. This is significant in some circumstances, like when a prankster sets row heights to 0.5. In this case, the cells are not visible, as if the rows were hidden, but the menu command Format - Row - Unhide will have no effect.
    Aloha,
    John Jacobson

  9. #9
    4 Star Lounger
    Join Date
    Mar 2004
    Location
    Griffith, New South Wales, Australia
    Posts
    507
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't see all rows (Win xp + Excel 2000)

    Thanks for all the responses.

    My real problem was that I was looking at the wrong menu to unhide. I dont use Excel much, and I was looking under Window | Hide /unhide instead of Format | Row | Unhide.

    A little more patience and attention to detail and less getting stressed as soon as it doesnt work the way that I think it should would probably work.

Posting Permissions

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