Help me with a quick excel question please. Arrow keys doing funny things.

(20 Posts)
MardyBra Mon 25-Mar-13 10:17:38

I'm sure there's a quick solution to this, but I can;'t for the life of me work it out.

I'm in excel and I've done something so that when I press one of the arrow keys, instead of moving to the next cell, it moves the whole spreadsheet.

It's driving me nuts. Can anyone tell me how to switch it back to normal.
I am using Excel for Mac btw.

Thanks in advance.

MardyBra Mon 25-Mar-13 10:26:44



LittlePebble Mon 25-Mar-13 10:32:20

Check you haven't got scroll lock on, that normally happens to me when I've pressed it.

ElizaCBennett Mon 25-Mar-13 10:39:41

Yes, I think switch scroll lock off!

SayCoolNowSayWhip Mon 25-Mar-13 10:40:39

YY scroll lock, or if you have a wheel mouse, sometimes if the scroller has been held down too long it can do funny things....

The ESC key is your friend (Or MAC equivalent...)

MardyBra Mon 25-Mar-13 10:41:51

OK trying to find scroll lock on mac

lljkk Mon 25-Mar-13 10:43:53

escape key.
Other solution is to quit and restart.

MardyBra Mon 25-Mar-13 10:45:36

It's been like this for a couple of weeks now, so escape and quitting not much good so far.
Nothing on help function for scroll lock.
Now googling

MardyBra Mon 25-Mar-13 10:49:03

OK, I've sound something telling me scroll lock is f14 on a mac keyboard. My keyboard only goes up to f12.

SayCoolNowSayWhip Mon 25-Mar-13 10:50:29

Try F14

MardyBra Mon 25-Mar-13 10:51:38

<hard stare at SayCool>

SayCoolNowSayWhip Mon 25-Mar-13 10:57:34

Sorry! Sorry! X posted.... blush

Are you able to get an onscreen keyboard and do it that way? I don't know Macs but on Windows you go Start, Accessories, Ease of Access and On Screen Keyboard...

<tries to make up for previous crapness>

MardyBra Mon 25-Mar-13 10:59:46

OK I've done it (no thanks for SayCool) by following

I got an onscreen virtual keyboard with an f14 button.
Will have to do some work now.

lljkk Mon 25-Mar-13 10:59:57

This is your problem, OP.

MardyBra Mon 25-Mar-13 11:00:20

Oh sorry SayCool. I missed that and was googling while you posted.

MardyBra Mon 25-Mar-13 11:01:33

Right. I'm sorted.
thanks to everyone (and apologies to SayCool)

SayCoolNowSayWhip Mon 25-Mar-13 11:02:00

Glad it's fixed Mardy grin

<takes full credit>

lljkk Mon 25-Mar-13 11:02:11

Try this:

"Try Fn + Shift + F12 (nice)

I found this on the MacBook Pro boot camp site:"

lljkk Mon 25-Mar-13 11:02:45

Xpost. Takes no Credit. <<Sulk>>

MardyBra Mon 25-Mar-13 11:03:10

thanks thanks thanks thanks thanks thanks to all.

Join the discussion

Join the discussion

Registering is free, easy, and means you can join in the discussion, get discounts, win prizes and lots more.

Register now