Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cannot scroll up past a certain row
I have a spread sheet that I cannot scroll to the top of the page. It seems
that I cannot go past row 240. I can scroll down with no problem and horizontal with no problem. Row 240 is not frozen. I can right mouse click on the right scroll bar and left mouse click on top. It does not goto the top. Any suggestions? C- |
#2
|
|||
|
|||
One possibility is that you may have accidentally Hidden rows 1-240 (based on
your info). Click the heading for any column, then go to FormatRowsUnhide. If that doesn't do it, please post back with any additional detail available incl. version info. HTH |:) "C-" wrote: I have a spread sheet that I cannot scroll to the top of the page. It seems that I cannot go past row 240. I can scroll down with no problem and horizontal with no problem. Row 240 is not frozen. I can right mouse click on the right scroll bar and left mouse click on top. It does not goto the top. Any suggestions? C- |
#3
|
|||
|
|||
My guess is that rows 1 - 239 are hidden. Have you tried unhiding them?
(Format, row, unhide, format column unhide) Carole O "C-" wrote: I have a spread sheet that I cannot scroll to the top of the page. It seems that I cannot go past row 240. I can scroll down with no problem and horizontal with no problem. Row 240 is not frozen. I can right mouse click on the right scroll bar and left mouse click on top. It does not goto the top. Any suggestions? C- |
#4
|
|||
|
|||
Perhaps rows 1 to 239 are hidden?
CTRL + A(twice in 2003) to select all cells. Right-click or a row header and "unhide". You are sure you do not have WindowFreeze Panes enabled? Gord Dibben Excel MVP On Wed, 23 Mar 2005 07:45:07 -0800, "C-" wrote: I have a spread sheet that I cannot scroll to the top of the page. It seems that I cannot go past row 240. I can scroll down with no problem and horizontal with no problem. Row 240 is not frozen. I can right mouse click on the right scroll bar and left mouse click on top. It does not goto the top. Any suggestions? C- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving Page with Scroll Bar | Excel Discussion (Misc queries) | |||
Scroll Lock | Excel Discussion (Misc queries) | |||
How do I restrict any one not to scroll more than 100 row? | Excel Worksheet Functions | |||
scroll bar | Excel Discussion (Misc queries) | |||
how to fit my column unmoved eventhough i scroll down? | New Users to Excel |