how do i get to top of excel page it seems to be missing

  • Thread starter Shattered and confused
  • Start date
S

Shattered and confused

HELP I seem to be missing the top of my excel page I have no arrows up,down
either at right of document PLEASE PLEASE HELP URGENT I need data
painstakingly entered
 
S

SteveW

Panic less.

Keep it Simple
First ensure that all the rows are not hidden
select Column A, then Format > Row > Unhide
And ensure that the Freeze Frame is off

Window > Unfreeze Panes
If the option is not there then they are unfrozen :)

Steve
 
R

RagDyeR

Try either:

<Ctrl> <A>
Then
<Format> <Rows> <Unhide>

OR

<Window> <UnFreeze Panes>
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


"Shattered and confused" <Shattered and [email protected]>
wrote in message HELP I seem to be missing the top of my excel page I have no arrows up,down
either at right of document PLEASE PLEASE HELP URGENT I need data
painstakingly entered
 
G

Gord Dibben

Maybe Tools>Options>View>Vertical Scrollbar needs to be checked?


Gord Dibben MS Excel MVP

On Sat, 28 Oct 2006 11:36:01 -0700, Shattered and confused <Shattered and
 
R

RagDyeR

Another thought:

When you "hide" a row, XL changes the height to 0, so it (XL) then knows to
enable the "unhide" command and return the row to it's original height.


However, if the row height is set to say a minimum of 0.25, even though it's
not visible, the "unhide", doesn't work.


So ... *Go To* Row1, and change the height to the default 12.75.

Hit <F5>
Type
A1
<Enter>
Then, <Format> <Row> <Height>,
And enter the default 12.75,
Then <OK>


If you then see Row1, select it, and the next visible row down, and increase
the height to say 13, to make all the "missing" rows visible.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================



"Shattered and confused" <Shattered and [email protected]>
wrote in message HELP I seem to be missing the top of my excel page I have no arrows up,down
either at right of document PLEASE PLEASE HELP URGENT I need data
painstakingly entered
 
R

RagDyeR

Interesting Gord, if he didn't think to try <Ctrl> <Home> to get to the top,
Even without the scroll bar.<bg>
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Maybe Tools>Options>View>Vertical Scrollbar needs to be checked?


Gord Dibben MS Excel MVP

On Sat, 28 Oct 2006 11:36:01 -0700, Shattered and confused <Shattered and
 
R

RagDyeR

Or even the UP and DOWN arrows!<g>
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

Interesting Gord, if he didn't think to try <Ctrl> <Home> to get to the top,
Even without the scroll bar.<bg>
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Maybe Tools>Options>View>Vertical Scrollbar needs to be checked?


Gord Dibben MS Excel MVP

On Sat, 28 Oct 2006 11:36:01 -0700, Shattered and confused <Shattered and
 
G

Gord Dibben

Hopefully we will get a response and find out if a resolution was attained.

Gord

Or even the UP and DOWN arrows!<g>
--

Regards,

RD
Click to expand...

Gord Dibben MS Excel MVP
 
S

Shattered and confused

RagDyeR said:
Another thought:

When you "hide" a row, XL changes the height to 0, so it (XL) then knows to
enable the "unhide" command and return the row to it's original height.


However, if the row height is set to say a minimum of 0.25, even though it's
not visible, the "unhide", doesn't work.


So ... *Go To* Row1, and change the height to the default 12.75.

Hit <F5>
Type
A1
<Enter>
Then, <Format> <Row> <Height>,
And enter the default 12.75,
Then <OK>


If you then see Row1, select it, and the next visible row down, and increase
the height to say 13, to make all the "missing" rows visible.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

THANK YOU THANX Ctrl Home did the trick. sorry very new at this

"Shattered and confused" <Shattered and [email protected]>
wrote in message HELP I seem to be missing the top of my excel page I have no arrows up,down
either at right of document PLEASE PLEASE HELP URGENT I need data
painstakingly entered
Click to expand...
 
S

Shattered and confused

RagDyeR said:
Another thought:

When you "hide" a row, XL changes the height to 0, so it (XL) then knows to
enable the "unhide" command and return the row to it's original height.


However, if the row height is set to say a minimum of 0.25, even though it's
not visible, the "unhide", doesn't work.


So ... *Go To* Row1, and change the height to the default 12.75.

Hit <F5>
Type
A1
<Enter>
Then, <Format> <Row> <Height>,
And enter the default 12.75,
Then <OK>


If you then see Row1, select it, and the next visible row down, and increase
the height to say 13, to make all the "missing" rows visible.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================



"Shattered and confused" <Shattered and [email protected]>
wrote in message HELP I seem to be missing the top of my excel page I have no arrows up,down
either at right of document PLEASE PLEASE HELP URGENT I need data
painstakingly entered


I hope I am getting thru - thank you the Ctrl home got me there. relieved and a lot less stressed
Click to expand...
 
R

RagDyeR

Thanks for the feed-back ... And there's no need to be "sorry".
We all had to start somewhere, at one time or another.

However, you should be sorry if you forget, and ask this same question again
.... sometime in the future.<bg>
 
Top