9579 Views 7 Replies Latest reply: Nov 14, 2008 5:38 AM by mdarnell
With Excel open, go to the Excel preferences and see if there is anything available to unlock the scroll bar.
Changing how scroll bars work
You can customize how scroll bars work using options in the Appearance pane of System Preferences.
Choose Apple menu > System Preferences and click Appearance.
Select a scrolling style.
To see the content in a window jump to the next or previous page when you click below or above the scroller (on the right side of a window), select "Jump to the next page."
To see the content scroll to where you click in the scroll bar, select "Jump to here."
You can press and hold the Option key when you click in the scroll bar to momentarily switch to the other method of scrolling.
To see the contents of the window scroll smoothly (without jumping), select the "Use smooth scrolling" checkbox.
You can also click and hold the scroll arrows to move through a document. Use Appearance preferences to place scroll arrows together or at the top and bottom of the scroll bar.
*Some applications may allow you to scroll through a document in other ways, such as by dragging in the documents, using arrow keys, or by pressing the Space bar. If the content of the document you're viewing is completely visible in the window, scroll bars do not appear.*
I haven't seen anything in Excel preferences to modify this. From the various posts I've seen in other forums, it seems to be a longstanding issue. I saw one on a microsoft excel site that was dated 2004. But, crucially, there's got to be a keyboard combo that would perform the scroll lock function, right? I just can't find the documentation to say what it is.
Thanks for the tips on scroll bars though.
Just for the record -- this is probably not an approved Apple work-a-round, but it worked. Attached a microsoft natural keyboard via usb to the iMac. Turned off my wireless keyboard. Opened Excel and hit the scroll lock button, got a volume control icon on the iMac, so tried shift+scroll lock and it worked. Excel is now normal, even with the wireless keyboard back on and excel closed and reopened.
Life is never dull.