 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / October 2006how do i get to top of excel page it seems to be missing
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 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 > 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 Try either: <Ctrl> <A> Then <Format> <Rows> <Unhide> OR <Window> <UnFreeze Panes>  SignatureHTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== 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 Maybe Tools>Options>View>Vertical Scrollbar needs to be checked? Gord Dibben MS Excel MVP >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 Interesting Gord, if he didn't think to try <Ctrl> <Home> to get to the top, Even without the scroll bar.<bg> SignatureRegards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- 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 confused@discussions.microsoft.com> wrote: >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 Or even the UP and DOWN arrows!<g> SignatureRegards, 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> SignatureRegards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- 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 confused@discussions.microsoft.com> wrote: >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 Hopefully we will get a response and find out if a resolution was attained. Gord >Or even the UP and DOWN arrows!<g> >Interesting Gord, if he didn't think to try <Ctrl> <Home> to get to the top, >Even without the scroll bar.<bg> Gord Dibben MS Excel MVP 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. SignatureHTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== 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 > Another thought: > [quoted text clipped - 19 lines] > either at right of document PLEASE PLEASE HELP URGENT I need data > painstakingly entered 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> SignatureRegards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "RagDyeR" wrote: > Another thought: > [quoted text clipped - 19 lines] > increase > the height to say 13, to make all the "missing" rows visible. > Another thought: > [quoted text clipped - 21 lines] > > I hope I am getting thru - thank you the Ctrl home got me there. relieved and a lot less stressed |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.