Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how 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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get to top of excel page it seems to be missing
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 On Sat, 28 Oct 2006 19:36:01 +0100, Shattered and confused <Shattered and 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get to top of excel page it seems to be missing
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 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get to top of excel page it seems to be missing
Maybe ToolsOptionsViewVertical Scrollbar needs to be checked?
Gord Dibben MS Excel MVP On Sat, 28 Oct 2006 11:36:01 -0700, Shattered and confused <Shattered and 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get to top of excel page it seems to be missing
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 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get to top of excel page it seems to be missing
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 ToolsOptionsViewVertical Scrollbar needs to be checked? Gord Dibben MS Excel MVP On Sat, 28 Oct 2006 11:36:01 -0700, Shattered and confused <Shattered and 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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get to top of excel page it seems to be missing
Or even the UP and DOWN arrows!<g
-- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "RagDyeR" wrote in message ... 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 ToolsOptionsViewVertical Scrollbar needs to be checked? Gord Dibben MS Excel MVP On Sat, 28 Oct 2006 11:36:01 -0700, Shattered and confused <Shattered and 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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get to top of excel page it seems to be missing
Hopefully we will get a response and find out if a resolution was attained.
Gord On Sat, 28 Oct 2006 12:08:17 -0700, "RagDyeR" wrote: Or even the UP and DOWN arrows!<g -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "RagDyeR" wrote in message ... 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 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get to top of excel page it seems to be missing
"RagDyeR" wrote: 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 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 |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get to top of excel page it seems to be missing
"RagDyeR" wrote: 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 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 |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get to top of excel page it seems to be missing
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 -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Shattered and confused" wrote in message ... "RagDyeR" wrote: 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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format page number in excel footer to start at a specific page # | Excel Discussion (Misc queries) | |||
excel -10 sections - footer needs to say "Section # Page # | New Users to Excel | |||
Problem with Page Numbering | Excel Discussion (Misc queries) | |||
Page Numbers | Excel Discussion (Misc queries) | |||
changing page break in an excel file | New Users to Excel |