The arrow keys on the keyboard that came with my new iMac have suddenly stopped working in Excel for moving between cells. They will only scroll the page up and down and left to right. Surely I have just inadvertently changed some setting. But, I have no idea how to change it back because I have no idea what I may have changed! Help!
iMac, Mac OS X (10.6.8), flat silver keyboard with white key
If the above answers don't work, the following worked for me: F8 turns scroll lock ON. Function+F8 turns scroll lock OFF.
Do you have the scroll lock on? click command+F14
thank you for posting this! i have an imac and was able to use command F14 to get the arrow keys on Excel working again. I was getting so frustrated that the arrow keys had been stuck on moving the entire page. I asked at an Apple store in a personal one to one session but no one there knew, so your post was a life saver!!!
Eric!!!! I thought all this time that nobody answered my question. And there it was, all the way back in October of 2011. I guess I thought someone would knock on my door and tell me my question had been answered.
Thinking all was for naught, I plugged in my PC keyboard and fixed the problem and then unplugged it.
Anyway, the keystrokes you suggested work wonderfully AND I am awestruck by the link you suggested. I want you to know, I googled the problem and read everything I found and not one person ever mentioned the Mac keystrokes for accomplishing "F-14".
You are the King. Actually, if you can answer the question I just posted in Airport Express, I'll be your personal slave. (It's called, "Murder on the Airport Express....")
My Airport Express doesn't extend my Wireless Network.
Hopefully this helps someone else. My arrow keys stopped working in Excel and I followed all of the examples here. It wasn't till I looked for "Scroll Lock" that I finally found the solution.
F14 is the Scroll Lock key. If you have fKeys set to "Keys", you may need to use the Fn key with it.
This has been a terrible annoyance.
Eric, I am on MacBook Pro and I don't have the F14 key. FN+Shift+F12 only brings up my dashboard. FN+Shift+F12 + command doesn't do anything. I'm still unable to work with Excel like before. OpenOffice on the other hand is just fine. Thanks for any of your input.
Since updating to Excel 2011 v14.5.0, my arrow keys, return, and tab all stopped working.
I've tried the Fn14 (shift+fn+f12) but that hasn't helped. This isn't a scroll lock problem.
Everything was going well until this v14.5 update. This is so frustrating!
Any suggestions to try?
I just wanted to thank you for this post. This happened to me many months back and I just now took the time to try to find the answer. I found your answer first and that solved my problem! So simple and yet so frustrating for so many months! Thanks again!
It's FN+Shift+F12, Take a look at this link, http://support.apple.com/kb/HT1220
Geat idea, that! Where do I find the F14 key on my MacBook Pro and/or my Extended Keyboard (both purchased mid 2010)?????
Thank you!!!!! Your a Genius!!! You just saved me a weeks worth of research!!
Thanks Eric worked like a charm.
Had the same problem in excel! Now indeed solved with F14!
Super thanks!
arrow keys stopped working in excel
