hidden rows in Excel

[David]

I have a multi sheet Excel file and on one of the sheets, I cannot view the
top two rows. I have tried every way I know and in help to unhide these rows
but to no avail. I am able to access them. One thing I am unable to do is to
try to change their height as I don't get the cursor sign to do this when
approching the select all cells button. maybe this has something to do with
it. The sheet has been protected but is currently unprotected.

Can anybody help please ?

[CyberTaz]

Hi David-

Have you tried this one:

Click the cell reference in the Name Box (left end of the formula bar), to
select the content appearing there, then type in A1:A2 to replace it, then
press Enter. Immediately go to Format>Row>Unhide.

HTH |:>)

"David" wrote:

> I have a multi sheet Excel file and on one of the sheets, I cannot view the
> top two rows. I have tried every way I know and in help to unhide these rows
> but to no avail. I am able to access them. One thing I am unable to do is to
> try to change their height as I don't get the cursor sign to do this when
> approching the select all cells button. maybe this has something to do with
> it. The sheet has been protected but is currently unprotected.
>
> Can anybody help please ?

[David]

Hi Cyber Taz, thanks but I've already tried that and it doesn't work. Thanks
for your input though.

"CyberTaz" wrote:

> Hi David-
>
> Have you tried this one:
>
> Click the cell reference in the Name Box (left end of the formula bar), to
> select the content appearing there, then type in A1:A2 to replace it, then
> press Enter. Immediately go to Format>Row>Unhide.
>
> HTH |:>)
>
> "David" wrote:
>
> > I have a multi sheet Excel file and on one of the sheets, I cannot view the
> > top two rows. I have tried every way I know and in help to unhide these rows
> > but to no avail. I am able to access them. One thing I am unable to do is to
> > try to change their height as I don't get the cursor sign to do this when
> > approching the select all cells button. maybe this has something to do with
> > it. The sheet has been protected but is currently unprotected.
> >
> > Can anybody help please ?

[Gary76]

How about

Window > Unfreeze Panes

HTH

"David" wrote:

> Hi Cyber Taz, thanks but I've already tried that and it doesn't work. Thanks
> for your input though.
>
> "CyberTaz" wrote:
>
> > Hi David-
> >
> > Have you tried this one:
> >
> > Click the cell reference in the Name Box (left end of the formula bar), to
> > select the content appearing there, then type in A1:A2 to replace it, then
> > press Enter. Immediately go to Format>Row>Unhide.
> >
> > HTH |:>)
> >
> > "David" wrote:
> >
> > > I have a multi sheet Excel file and on one of the sheets, I cannot view the
> > > top two rows. I have tried every way I know and in help to unhide these rows
> > > but to no avail. I am able to access them. One thing I am unable to do is to
> > > try to change their height as I don't get the cursor sign to do this when
> > > approching the select all cells button. maybe this has something to do with
> > > it. The sheet has been protected but is currently unprotected.
> > >
> > > Can anybody help please ?

[David]

What a man Gary, that was it ! What an idiot I am for not noticing the lines.
Thanks very much

David

"Gary76" wrote:

> How about
>
> Window > Unfreeze Panes
>
> HTH
>
> "David" wrote:
>
> > Hi Cyber Taz, thanks but I've already tried that and it doesn't work. Thanks
> > for your input though.
> >
> > "CyberTaz" wrote:
> >
> > > Hi David-
> > >
> > > Have you tried this one:
> > >
> > > Click the cell reference in the Name Box (left end of the formula bar), to
> > > select the content appearing there, then type in A1:A2 to replace it, then
> > > press Enter. Immediately go to Format>Row>Unhide.
> > >
> > > HTH |:>)
> > >
> > > "David" wrote:
> > >
> > > > I have a multi sheet Excel file and on one of the sheets, I cannot view the
> > > > top two rows. I have tried every way I know and in help to unhide these rows
> > > > but to no avail. I am able to access them. One thing I am unable to do is to
> > > > try to change their height as I don't get the cursor sign to do this when
> > > > approching the select all cells button. maybe this has something to do with
> > > > it. The sheet has been protected but is currently unprotected.
> > > >
> > > > Can anybody help please ?

[Pastel Hughes]

I think that the pane freezing that Gary mentioned is the likely culprit.
If not, you could try highlighting the entire sheet by clicking in the small
grey area above row 1 and to the left of column A, then Format Row Unhide.

"David" wrote:

> I have a multi sheet Excel file and on one of the sheets, I cannot view the
> top two rows. I have tried every way I know and in help to unhide these rows
> but to no avail. I am able to access them. One thing I am unable to do is to
> try to change their height as I don't get the cursor sign to do this when
> approching the select all cells button. maybe this has something to do with
> it. The sheet has been protected but is currently unprotected.
>
> Can anybody help please ?

[David]

Thanks, problem is solved, the panes were frozen.

"Pastel Hughes" wrote:

> I think that the pane freezing that Gary mentioned is the likely culprit.
> If not, you could try highlighting the entire sheet by clicking in the small
> grey area above row 1 and to the left of column A, then Format Row Unhide.
>
> "David" wrote:
>
> > I have a multi sheet Excel file and on one of the sheets, I cannot view the
> > top two rows. I have tried every way I know and in help to unhide these rows
> > but to no avail. I am able to access them. One thing I am unable to do is to
> > try to change their height as I don't get the cursor sign to do this when
> > approching the select all cells button. maybe this has something to do with
> > it. The sheet has been protected but is currently unprotected.
> >
> > Can anybody help please ?