Excel scrolling

[CleveOH]

Have a bit of a dilema... My company's BIG boss is working on an Excel 2000
spreadsheet. When he opens it, he is not able to scroll DOWN at all... He can
scroll left and right, but not down... He can click on a cell and then down
arrow past the cells that show up on the screen, but it won't scroll down...
This is the only spreadsheet in which this happens... Any ideas / suggestions?

 

[Kevin B]

Verify that someone has not set a scroll area for the worksheet by pressing
Alt + F8 to open the Visual Basic window. You should have the Project window
and the Properties window displayed on the left side of the screen below the
menu.

Click the worksheet name in that the proplem is occurring on in the Project
Window and then take a look at the Properties window and locate the
ScrollArea property. If there is a range address (like A1:IV1) set in this
property the user can only scroll through the designated range.

Remove the range address, click FILE on the menu and select CLOSE AND RETURN
TO EXCEL. Save the workbook and verify that the worksheet is scrollable.

 

[Stefi]

Check Tools>Options>Display tab, Vertical scroll bar!
This is a workbook specific property.

Regards,
Stefi

„CleveOH†ezt írta:

 

[CleveOH]

Kevin - thanks, I'll check into that as soon as I can...

Stefi - thanks, but it's not that the scroll bar isn't there, because it
is.... He just can't scroll past a certain point and have the data scroll
along (if that makes sense)

 

[Alojz]

what about unfreeze panes?

 

[Gord Dibben]

Maybe Window>Freeze Panes is set?


Gord Dibben MS Excel MVP