My feed
Premium

Please
or
to access all these features

Geeky stuff

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

19 replies

MardyBra · 25/03/2013 10:17

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.

OP posts:
Report
MardyBra · 25/03/2013 10:26

Anyone?

Please?

OP posts:
Report
LittlePebble · 25/03/2013 10:32

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

Report
ElizaCBennett · 25/03/2013 10:39

Yes, I think switch scroll lock off!

Report
SayCoolNowSayWhip · 25/03/2013 10:40

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...)

Report
MardyBra · 25/03/2013 10:41

OK trying to find scroll lock on mac

OP posts:
Report
lljkk · 25/03/2013 10:43

escape key.
Other solution is to quit and restart.

Report
MardyBra · 25/03/2013 10:45

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

OP posts:
Report
MardyBra · 25/03/2013 10:49

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

OP posts:
Report
SayCoolNowSayWhip · 25/03/2013 10:50

Try F14

Report
MardyBra · 25/03/2013 10:51
OP posts:
Report
SayCoolNowSayWhip · 25/03/2013 10:57

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...

Report
MardyBra · 25/03/2013 10:59

OK I've done it (no thanks for SayCool) by following
this:gigaom.com/2008/09/24/mac-101-get-an-onscreen-keyboard-in-osx/

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

OP posts:
Report
lljkk · 25/03/2013 10:59
Report
MardyBra · 25/03/2013 11:00

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

OP posts:
Report
MardyBra · 25/03/2013 11:01

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

OP posts:
Report
SayCoolNowSayWhip · 25/03/2013 11:02

Glad it's fixed Mardy Grin

Report
lljkk · 25/03/2013 11:02

Try this:

"Try Fn + Shift + F12 (nice)

I found this on the MacBook Pro boot camp site:

support.apple.com/kb/HT1220"

Report
lljkk · 25/03/2013 11:02

Xpost. Takes no Credit.

Report
MardyBra · 25/03/2013 11:03

Thanks Thanks Thanks Thanks Thanks Thanks to all.

OP posts:
Report
Please create an account

To comment on this thread you need to create a Mumsnet account.