I’ve been using Excel forever, and I use a lot of keyboard shortcuts. My grandson was goofing around with my computer the other day, and the arrow keys no longer move the cursor to another cell; they scroll the worksheet… It’s driving me nuts, and I spent a good 20 minutes searching through all of the preferences and tools trying to find what setting he changed so I can change it back. Can anyone help me with this?
I’m using Excel 2004 on Mac OS 10.5.8.
Thanks!
In Windows having scroll lock on will do this.
This. Apologies to the OP if I’m stating the obvious, but scroll lock is a key on your keyboard, usually somewhere off the right end of the function (F1-F12) keys. Often there’s an indicator light somewhere on your keyboard (typically near the caps-lock indicator light) that tells you whether scroll lock is turned on or not.
That’s all fine and dandy for Windows users, Joe, but Macs don’t have scroll lock keys (and the caps-lock indicator light is on the caps-lock key).
ETA: So I went back to Excel and turned on the status bar. Sure enough, there’s an “SCRL” indicator at the bottom, and it’s lit up. So how the heck do I turn it off?
So I started pushing every stinking key on the keyboard. Microsoft seems to have randomly designated the Macintosh F14 key as Scroll Lock on a Mac. Of course, they don’t ship manuals with their software anymore, and “Scroll Lock” doesn’t appear in their online help files.
Sorry, in my frustration with Microsoft I forgot to say thanks for the help, folks.
I don’t have Office 2003 handy (which is the equivalent of Mac 2004 I believe), but can you also double click on the “SCRL” to change it’s status? I think that’s the way it works with “OVR” in Word.
Not to rub salt, but Googling “excel mac scroll lock” returned many hits, the first with the solution.
Understood, but since the Mac doesn’t have a scroll lock key, it never occurred to me to search for it. Microsoft took a Windows concept and implemented it in Mac software without putting it on a menu, which is where I searched for it.
And no, thelurkinghorror, I tried clicking on it, double-clicking, right-clicking, double-right-clicking… Then I figured it was probably some key on the keyboard and started trying function keys.
Sorry, Gary. I had lost track of the fact that you didn’t discover the SCRL indicator on the screen until after you’d already been troubleshooting it here. I misremembered it as part of the initial conditions of the problem.
Not a problem.