ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Unhide row a1 (https://www.excelbanter.com/excel-discussion-misc-queries/171873-unhide-row-a1.html)

Stuck in California

Unhide row a1
 
I've tried all the suggestions to unhide row a1. None have worked so far.
Any other thoughts on a forever hidden a1?

Stuck in California

RagDyeR

Unhide row a1
 
Hit <F5 (Go To)
Type in
A1
Then hit <Enter

Then, from the Menu Bar,
<Format <Row <Unhide.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Stuck in California" <Stuck in wrote
in message ...
I've tried all the suggestions to unhide row a1. None have worked so far.
Any other thoughts on a forever hidden a1?

Stuck in California



Tyro[_2_]

Unhide row a1
 
A1 is a cell, not a row.

If you mean row 1 is hidden, then press F5, then enter A1 in the reference
box, click OK. Then (not Excel 2007) Format/Row/Unhide. If Excel 2007 then
Home/Format/Visiblity/Unhide Rows

tyro

"Stuck in California" <Stuck in wrote
in message ...
I've tried all the suggestions to unhide row a1. None have worked so far.
Any other thoughts on a forever hidden a1?

Stuck in California




Dave Peterson

Unhide row a1
 
Just to add...

If you still can't see row 1 (or column A???), try unfreezing the panes:

Window|Unfreeze panes
(xl2003 menu)

Stuck in California wrote:

I've tried all the suggestions to unhide row a1. None have worked so far.
Any other thoughts on a forever hidden a1?

Stuck in California


--

Dave Peterson

Stuck in California[_2_]

Unhide row a1 Thanks it was the frozen panes that was the problem
 


"Dave Peterson" wrote:

Just to add...

If you still can't see row 1 (or column A???), try unfreezing the panes:

Window|Unfreeze panes
(xl2003 menu)

Stuck in California wrote:

I've tried all the suggestions to unhide row a1. None have worked so far.
Any other thoughts on a forever hidden a1?

Stuck in California


--

Dave Peterson


Stuck in California[_2_]

Unhide row a1
 

Thanks -- unfreezing the panes was the solution!


"Dave Peterson" wrote:

Just to add...

If you still can't see row 1 (or column A???), try unfreezing the panes:

Window|Unfreeze panes
(xl2003 menu)

Stuck in California wrote:

I've tried all the suggestions to unhide row a1. None have worked so far.
Any other thoughts on a forever hidden a1?

Stuck in California


--

Dave Peterson



All times are GMT +1. The time now is 02:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com