Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
C-
 
Posts: n/a
Default 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   Report Post  
CyberTaz
 
Posts: n/a
Default

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   Report Post  
Carole O
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving Page with Scroll Bar CMM Excel Discussion (Misc queries) 1 March 1st 05 07:07 AM
Scroll Lock jrh Excel Discussion (Misc queries) 0 January 18th 05 03:38 PM
How do I restrict any one not to scroll more than 100 row? Saadi Excel Worksheet Functions 1 January 7th 05 07:25 PM
scroll bar Yevgeny Azrieli Excel Discussion (Misc queries) 1 December 16th 04 05:39 PM
how to fit my column unmoved eventhough i scroll down? Zxing New Users to Excel 1 November 28th 04 06:28 AM


All times are GMT +1. The time now is 03:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"