First, thanks to everyone for their thoughtful replies.
I was able to resize the row using Peo's suggestion, as I was able to just
drag the row down to reveal it. The strange thing to me is that it won't
function as it should - and has in the past - by just selecting the row and
unhiding it.
In answer to the other question, I just hid it normally by selecting Row -
Hide from the menu. "Hide" works, but "Unhide" suddendly does not. It's not
that I can't get to the row. It's just strange to me that I can't unhide it.
This is a function I've used often and successfully for quite a while that
suddenly won't work.
"Peo Sjoblom" wrote:
> Press F5 and type in a cell address in this particular row, so if it is row
> 5 type for instance in A5,
> then do format>row>height and select 12.75 and press enter
>
>
> --
> Regards,
>
> Peo Sjoblom
>
> (No private emails please, for everyone's
> benefit keep the discussion in the newsgroup/forum)
>
>
>
> "JBurke" <JBurke@discussions.microsoft.com> wrote in message
> news:B9344B18-F24D-495B-B2BD-4EB87BC594C7@microsoft.com...
> > Yes. "Unhide" does show up, but when you selected it nothing seems to
> > happen. The sheet is not protected, and I am selecting the rows above and
> > below the hidden rows.
> >
> > That's why it's so puzzling to me. Thanks for writing back.
> >
> > BTW...It's Excel 2003 SP1.
> >
> > "RWN" wrote:
> >
> >> Does the "UnHide" show up on the menu (or is it greyed out - protected
> >> sheet).
> >>
> >> Are you selecting the rows on either side of the hidden rows?
> >>
> >> --
> >> Regards;
> >> Rob
> >> ------------------------------------------------------------------------
> >> "JBurke" <JBurke@discussions.microsoft.com> wrote in message
> >> news:7FD4E7BC-76E7-4BE2-ABF4-7789A13C8E00@microsoft.com...
> >> > A new problem in Excel - when I hide a row, suddenly I can't use the
> >> > "unhide"
> >> > menu command to unhide the row. I have to use the tool and pull it
> >> > down and
> >> > resize it. Anyone experienced this? Thanks
> >>
> >>
> >>
>
>
>
Bookmarks