Why can't I unhide a hiden row

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

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

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
>
>
>

Hi J,

I would guess that the row's height has been set to a very low size. Try
resizing the relevant row.

---
Regards,
Norman



"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
>>
>>
>>

Hi J,

Another thought, how did you hide the row?

---
Regards,
Norman



"Norman Jones" <normanjones@whereforartthou.com> wrote in message
news:O6b1afS9EHA.4072@TK2MSFTNGP10.phx.gbl...
> Hi J,
>
> I would guess that the row's height has been set to a very low size. Try
> resizing the relevant row.
>
> ---
> Regards,
> Norman
>

Ahhh.

I bet you're thinking: Data|filter|show all
or some sort of unfiltering action.

Norman Jones wrote:
>
> Hi J,
>
> Another thought, how did you hide the row?
>
> ---
> Regards,
> Norman
>
> "Norman Jones" <normanjones@whereforartthou.com> wrote in message
> news:O6b1afS9EHA.4072@TK2MSFTNGP10.phx.gbl...
> > Hi J,
> >
> > I would guess that the row's height has been set to a very low size. Try
> > resizing the relevant row.
> >
> > ---
> > Regards,
> > Norman
> >

--

Dave Peterson

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
>>
>>
>>

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
> >>
> >>
> >>
>
>
>