Scrolling madness

[buckley22]

Hi there.

Git a bit of a wierd issue and its driving me bonkers cos I can't think of how to solve it.

On one of my spreadsheets at work the vertical scrolling thats operated by the mouse (like muliple selecting cells) or by the keyboard (page up/down, or even by using the arrow keys to move the active cell off the screen) has just stopped working. It's only for this file as my others work fine. But oddly enough I can still scroll fine using the scroll bar on the right hand side and all of these options work fine when applied to horizontal scrolling

I'm stumped

HELP ME!

thanks

 

[milesUK]

buckley22, I can replicate this by Freezing Panes with the active cell way down the sheet. Unfreeze panes from the Window menu. Scroll lock is another way that scrolling behaves unexpectedly though not as you have described.
Miles

 

[buckley22]

Wahoo!!!...**** shows how tired I am this morning.....should've thought of that really.....ah well no idea how I managed to do that cos I always have the top line frozen anyway and it stayed frozen when I was scrolling with the scroll bar......bizarre.....still managed to get it working now anyways

Thanks a million

 

[milesUK]

Your welcome.
What a way to cure Monday morning blues - succesfully help someone.
M.