RE: Unhiding rows in Excel 2002?
- From: Bill Tipton <billtipton@xxxxxxxxxxxxx>
- To: jfw@xxxxxxxxxxxxx
- Date: Sat, 16 Apr 2005 10:31:40 -0700
Hi,
Thanks, this works great on one of my documents. I think I have the hang of
it now.
In another document I am having problems. I can hide some rows, but cannot
unhide them. In another document I can hide and unhide the rows with the
technique you told me about with no problem. It is only on this one
document that seems to have this issue.
Is there some setting that will allow me to hide rows, but not allow me to
unhide them?
Under the cells setting there is something called locked. in one document
this is checked and in the other it is unchecked. I set this option the
same for both documents , but no luck still allows me to hide, but not unhide.
I have to admit I am a novice at Excel , so could be doing something wrong.
Thanks for your help.
Bill
At 09:51 PM 4/14/2005 -0700, you wrote:
>Yes, but when you highlite the two cells like you described, then go to
>format and errow to rows now not collums and hit enter and then choose
>unhide and hit o k and you should have them all back.
>
>-----Original Message-----
>From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On =
>Behalf
>Of Bill Tipton
>Sent: Thursday, April 14, 2005 15:05
>To: jfw@xxxxxxxxxxxxx
>Subject: RE: Unhiding rows in Excel 2002?
>
>Hi,
>
>I must have done something wrong.
>I have a row at C 5 with data that is viewable.
>Then it jumps to c500 with no viewable data.
>Do I highlight c5 and c500 by putting my cursor on C5 then push=20
>shift-control and the down arrow to highlight those two cells? Then do =
>your=20
>procedure.
>
>Please let me know if you have any questions if my explanation is not =
>clear.
>
>Thanks
>
>Bill
>
>
>
>At 06:27 AM 4/14/2005 -0700, you wrote:
> >Bill,
> >
> >What you need to do is;
> >In your excel spread sheet, highlite one cell on each side of the =
>hidden
> >collum, (the cells need to be in the same row). Then, after they are
> >highlited, go to format on the menu bar, and errow to collums, and then
> >select unhide collums and they are back for you.
> >
> >Any other questions please ask.
> >
> >hth
> >
> >-----Original Message-----
> >From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On =3D
> >Behalf
> >Of Bill Tipton
> >Sent: Wednesday, April 13, 2005 19:28
> >To: jfw@xxxxxxxxxxxxx
> >Subject: Unhiding rows in Excel 2002?
> >
> >Hi,
> >
> >How do you unhide rows in a Excel spreadsheet. I am using Jaws 6.0 =
>and=3D20
> >Excel 2002.
> >
> >I do not even know if this is the correct term (unhiding rows). I just =
>=3D
> >have=3D20
> >a Excel spreadsheet I am working on with other people. Now some of the =
>=3D
> >rows=3D20
> >are missing. I can tell by the numbering on the columns, there are =
>gaps=3D20
> >missing. Plus data is missing. I think they might have performed a sort =
>=3D
> >on=3D20
> >the file.
> >
> >How can I see the complete spreadsheet again or move to other =
>sorted=3D20
> >regions? I actually like the sort, so if it is easy to move between =3D
> >areas=3D20
> >that would be best.
> >
> >Thanks for your help.
> >
> >Bill
> >
> >
> >
> >
> >--
> >To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> >To unsubscribe from this mailing list, send a message to
> >jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject =
>line.
> >Archives located at: //www.freelists.org/archives/jfw
> >
> >If you have any concerns about the list, post received from the list, =
>or =3D
> >the
> >way the list is being run, do not post them to the list. Rather contact =
>=3D
> >the
> >list owner at jfw-admins@xxxxxxxxxxxxxx
> >
> >--
> >To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> >To unsubscribe from this mailing list, send a message to=20
> >jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject =
>line.
> >Archives located at: //www.freelists.org/archives/jfw
> >
> >If you have any concerns about the list, post received from the list, =
>or=20
> >the way the list is being run, do not post them to the list. Rather=20
> >contact the list owner at jfw-admins@xxxxxxxxxxxxxx
>
>
>--
>To post a message to the list, send it to jfw@xxxxxxxxxxxxx
>To unsubscribe from this mailing list, send a message to
>jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
>Archives located at: //www.freelists.org/archives/jfw
>
>If you have any concerns about the list, post received from the list, or =
>the
>way the list is being run, do not post them to the list. Rather contact =
>the
>list owner at jfw-admins@xxxxxxxxxxxxxx
>
>--
>To post a message to the list, send it to jfw@xxxxxxxxxxxxx
>To unsubscribe from this mailing list, send a message to
>jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
>Archives located at: //www.freelists.org/archives/jfw
>
>If you have any concerns about the list, post received from the list, or
>the way the list is being run, do not post them to the list. Rather
>contact the list owner at jfw-admins@xxxxxxxxxxxxxx
--
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
Other related posts:
