Page 1 of 2 12 LastLast
Results 1 to 10 of 17

I can't unhide rows?

This is a discussion on I can't unhide rows? within the Excel Questions forums, part of the Question Forums category; Hi, Peoples. I have a workbook in which I can't unhide 10 hidden rows (91 thru 100). The workbook and ...

  1. #1
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,055

    Default I can't unhide rows?

    Hi, Peoples.

    I have a workbook in which I can't unhide 10 hidden rows (91 thru 100). The workbook and worksheet are unprotected. There is no VBA code in the workbook. Does anyone know why this may be happening?

    Thanks,

    Barry
    Barry-

    Photo Restoration/Enhancement

    http://www.smiledogproductions.com
    click below for detour


  2. #2
    Board Regular
    Join Date
    Dec 2002
    Posts
    60

    Default Re: I can't unhide rows?

    Do you have panes frozen?

  3. #3
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    69,371

    Default Re: I can't unhide rows?

    Maybe someone's set the row height to a very low number, which is not the same as hiding it. Try Format|Row|Height instead of Unhide.

  4. #4
    Spammer
    Join Date
    Jan 2004
    Location
    in the process of locating.
    Posts
    372

    Default Re: I can't unhide rows?

    try by adjusting row height, rather than un-hide

  5. #5
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,055

    Default Re: I can't unhide rows?

    Sorry, my internet connection keeps going kaploooie....

    Nope, neither one. No frozen panes, and I tried formatting the row height; doesn't expose the rows. Any other ideas?

    Barry
    Barry-

    Photo Restoration/Enhancement

    http://www.smiledogproductions.com
    click below for detour


  6. #6
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    69,371

    Default Re: I can't unhide rows?

    Try this.

    Right click the header of the row above the hidden rows, choose Row Height and click OK. Hold down Shift, click the header of the row below the hidden rows and press F4.

  7. #7
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,008

    Default Re: I can't unhide rows?

    Also, check to make sure your sheet is not in Filter mode. Click on Data > Filter and see if Show All needs to be selected.

  8. #8
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,055

    Default Re: I can't unhide rows?

    Thanks, Andrew & Tom. I checked Filter first and, sure 'nuff, that was what it wuz. The filter-unfilter code in my print macro was wacked. Oh well, another day, another screw-up.

    Thanks again.
    Barry-

    Photo Restoration/Enhancement

    http://www.smiledogproductions.com
    click below for detour


  9. #9
    New Member
    Join Date
    Dec 2011
    Posts
    1

    Default Re: I can't unhide rows?

    Thank you for this thread. It helped me also.

  10. #10
    New Member
    Join Date
    May 2012
    Posts
    1

    Default Re: I can't unhide rows?

    Me too!

Page 1 of 2 12 LastLast

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
  •  


DMCA.com