Scrolloing in Excel

[colinsears]

Help,

I seem to have flicked a switch somewhere that I cannot turn off. I
have a spreadsheet with some 2000 lines of data.

I can no longer scroll through the data using the up or down arrows or
the mouse wheel.. When I do scroll down or up using the up or down
arrows the cursor continues to move off the end of the page without me
being able to see where it has gone, i.e the page is no longer
'active'. My mouse wheel has ceased to work also.

When I do a 'Find' for the data the cursor goes to the data but does
not take my view to that data

I can do any work as normal on the data in view.

Page down and Page up work fine.

Any Ideas? Thanks.

 

[ChrisM]

In message (e-mail address removed),

Help,

I seem to have flicked a switch somewhere that I cannot turn off. I
have a spreadsheet with some 2000 lines of data.

I can no longer scroll through the data using the up or down arrows or
the mouse wheel.. When I do scroll down or up using the up or down
arrows the cursor continues to move off the end of the page without me
being able to see where it has gone, i.e the page is no longer
'active'. My mouse wheel has ceased to work also.

When I do a 'Find' for the data the cursor goes to the data but does
not take my view to that data

I can do any work as normal on the data in view.

Page down and Page up work fine.

Any Ideas? Thanks.

Scroll Lock button??

 

[ChrisM]

In message (e-mail address removed),

Help,

I seem to have flicked a switch somewhere that I cannot turn off. I
have a spreadsheet with some 2000 lines of data.

I can no longer scroll through the data using the up or down arrows or
the mouse wheel.. When I do scroll down or up using the up or down
arrows the cursor continues to move off the end of the page without me
being able to see where it has gone, i.e the page is no longer
'active'. My mouse wheel has ceased to work also.

When I do a 'Find' for the data the cursor goes to the data but does
not take my view to that data

I can do any work as normal on the data in view.

Page down and Page up work fine.

Any Ideas? Thanks.

Sorry, not ScrollLock is it...

Sounds more like you've created a virtual desktop that's bigger than your
screen size or something...

 

[CyberTaz]

What version of Excel is this (and why did you post to a Word newsgroup?)?

You might try taking a look in the Window menu to see if there is a Remove
Split or UnFreeze Panes command. If so, select it to turn the feature off.

If that isn't the problem, post your question to the microsoft.public.excel
group for more information. If you're new to newsgroups you might want to
review this beforehand:

http://word.mvps.org/FindHelp/Posting.htm

http://www.microsoft.com/windowsxp/expertzone/newsgroups.mspx

 

[Sparky1000]

What version of Excel is this (and why did you post to a Word newsgroup?)?

You might try taking a look in the Window menu to see if there is a Remove
Split or UnFreeze Panes command. If so, select it to turn the feature off.

If that isn't the problem, post your question to the microsoft.public.excel
group for more information. If you're new to newsgroups you might want to
review this beforehand:

http://word.mvps.org/FindHelp/Posting.htm

http://www.microsoft.com/windowsxp/expertzone/newsgroups.mspx

--
HTH |:>)
Bob Jones
[MVP] Office:Mac












- Show quoted text -

Managed to freeze my panes. Thank You. Sorry about the wrong group
thing.

 

[CyberTaz]

Managed to freeze my panes. Thank You. Sorry about the wrong group
thing.

No Problem! It's just that you'll usually get more accurate & prompt
responses if you post to the appropriate group. Glad I could help.

Regards |:>)
Bob Jones
[MVP] Office:Mac