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?

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.
--
Kevin Backmann


"CleveOH" wrote:

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?

Check ToolsOptionsDisplay tab, Vertical scroll bar!
This is a workbook specific property.

Regards,
Stefi

€žCleveOH€� ezt Ã*rta:

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 - 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)

"Stefi" wrote:

Check ToolsOptionsDisplay tab, Vertical scroll bar!
This is a workbook specific property.

Regards,
Stefi

€žCleveOH€� ezt Ã*rta:

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?

what about unfreeze panes?

"CleveOH" wrote:

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?

Maybe WindowFreeze Panes is set?


Gord Dibben MS Excel MVP


On Fri, 27 Feb 2009 07:22:01 -0800, CleveOH
wrote:

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?