New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus • Advice and insight from world-class Apple enthusiasts • Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Simple Excel problem - number pad giving directions


Post Reply New Thread Subscribe

 
Thread Tools
toMACsh

 
toMACsh's Avatar
 
Member Since: Jul 30, 2009
Location: Wisconsin
Posts: 5,516
toMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to all
Mac Specs: Mac Mini Core 2 Duo

toMACsh is offline
Out of the blue, my number pad switched from giving numbers to navigating around the spreadsheet. That is, the 2 | 4 | 6 | 8 keys function like arrow keys. I know the answer is staring me in the face, but I can't see through the egg.

I've looked at my keyboard, tried the Insert key, looked through Excel preferences too. I can't find the right key or button to hit. Help! I want numbers; I have arrow keys already.
QUOTE Thanks
toMACsh

 
toMACsh's Avatar
 
Member Since: Jul 30, 2009
Location: Wisconsin
Posts: 5,516
toMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to all
Mac Specs: Mac Mini Core 2 Duo

toMACsh is offline
Wow! No one on this forum uses Excel?

New information: I noticed that the number pad works fine in Calculator. So, I opened a Numbers file, and it worked fine there too. It has to be an Excel thing.

Also, I did mess with the Num Lock key, but that did not change anything. I'm not sure my Num Lock key does anything at all. There is a light on the keyboard for it, but that is always off, no matter how many times I hit Num Lock. The light goes off and on for Caps Lock however.
QUOTE Thanks
chscag

 
chscag's Avatar
 
Member Since: Jan 23, 2008
Location: Fort Worth, Texas
Posts: 40,103
chscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond repute
Mac Specs: 27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, 3 iPods, OS X Mavericks

chscag is offline
I have Office installed but no longer mess with Excel. I'm strictly a Word and Powerpoint user. However, it does sound like your keyboard may have gone south on you. Do you have another you can try, one with a numeric keypad? Also, you might try a SMC and PRAM reset although I don't think either will work if the keyboard is having problems.
QUOTE Thanks
MYmacROX

 
MYmacROX's Avatar
 
Member Since: Mar 17, 2009
Posts: 3,613
MYmacROX is a name known to allMYmacROX is a name known to allMYmacROX is a name known to allMYmacROX is a name known to allMYmacROX is a name known to allMYmacROX is a name known to allMYmacROX is a name known to all
Mac Specs: 2008 15" MBP ML, 2012 21.5" iMac ML

MYmacROX is offline
You have Num Lock turned off. That lets you use the 2, 4, 6, 8 as arrow buttons.

This only works if Scroll Lock is off and Num Lock is off.

16GB iPhone 5, 64GB Wi-Fi only iPad 1st Gen.

Reminder: Please include your Mac's specs. This will make it much easier for the other members to assist you.
QUOTE Thanks
toMACsh

 
toMACsh's Avatar
 
Member Since: Jul 30, 2009
Location: Wisconsin
Posts: 5,516
toMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to all
Mac Specs: Mac Mini Core 2 Duo

toMACsh is offline
Thanks for the input. I'll play around with those tonight and see if I can get it to behave. The interesting thing is that in Numbers, I get numbers... without touching Num Lock after just getting arrow key behavior in Excel. I do not have a spare USB keyboard to try, unfortunately.
QUOTE Thanks
toMACsh

 
toMACsh's Avatar
 
Member Since: Jul 30, 2009
Location: Wisconsin
Posts: 5,516
toMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to all
Mac Specs: Mac Mini Core 2 Duo

toMACsh is offline
No luck. No matter what I do with Num Lock and Scroll Lock, the number pad is stuck in "arrow mode" in Excel. Yet I still can get numbers out of it in Numbers. This must be an Excel issue. As I've used the number pad in Excel for years, some setting must have gotten changed. I have not installed anything new in quite some time, so that's ruled out. This is very puzzling, and annoying.
QUOTE Thanks
MYmacROX

 
MYmacROX's Avatar
 
Member Since: Mar 17, 2009
Posts: 3,613
MYmacROX is a name known to allMYmacROX is a name known to allMYmacROX is a name known to allMYmacROX is a name known to allMYmacROX is a name known to allMYmacROX is a name known to allMYmacROX is a name known to all
Mac Specs: 2008 15" MBP ML, 2012 21.5" iMac ML

MYmacROX is offline
Well, that's how I figured it out by playing with it on my work computer.

Windows 7 Enterprise with Excel 2007 using a standard HP keyboard. Maybe the Num Lock or Scroll Lock key is broken and stuck in the "Off" option.

16GB iPhone 5, 64GB Wi-Fi only iPad 1st Gen.

Reminder: Please include your Mac's specs. This will make it much easier for the other members to assist you.
QUOTE Thanks
nickyr

 
nickyr's Avatar
 
Member Since: Nov 01, 2007
Location: Swansea - South Wales
Posts: 471
nickyr is a jewel in the roughnickyr is a jewel in the rough
Mac Specs: late 2012 IMac 27", mid 2010 Macbook, OSX 10.10, iPhone 5, iPad 3, iOS 8, Apple TV 3, iPod Classic

nickyr is offline
could this be your problem?

OS X Lion: Shortcuts for Mouse Keys

what have the Roman's ever done for us?

QUOTE Thanks
toMACsh

 
toMACsh's Avatar
 
Member Since: Jul 30, 2009
Location: Wisconsin
Posts: 5,516
toMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to all
Mac Specs: Mac Mini Core 2 Duo

toMACsh is offline
Quote:
Originally Posted by nickyr View Post
could this be your problem?

OS X Lion: Shortcuts for Mouse Keys
Well, I'm using Leopard, but I'll look into this. Thanks!
QUOTE Thanks
toMACsh

 
toMACsh's Avatar
 
Member Since: Jul 30, 2009
Location: Wisconsin
Posts: 5,516
toMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to all
Mac Specs: Mac Mini Core 2 Duo

toMACsh is offline
Quote:
Originally Posted by MYmacROX View Post
Maybe the Num Lock or Scroll Lock key is broken and stuck in the "Off" option.
That could explain why I'm having this problem in Excel. But, it wouldn't explain why I'm not having the problem in Numbers.

(Come to think of it, neither would the suggestion in the link in that other post...)
QUOTE Thanks
cradom

 
cradom's Avatar
 
Member Since: Feb 14, 2004
Location: Nederland, Texas
Posts: 3,203
cradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant future
Mac Specs: 21in iMac core2 Duo- 13in macbook - 10.9 on both

cradom is offline
Try pressing shift-clear, or shift-F14, depending on the keyboard.

Craig Domingue - resident redneck.
“Never argue with an idiot. He will only bring you down to his level and beat you with experience.”, George Carlin
QUOTE Thanks
toMACsh

 
toMACsh's Avatar
 
Member Since: Jul 30, 2009
Location: Wisconsin
Posts: 5,516
toMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to all
Mac Specs: Mac Mini Core 2 Duo

toMACsh is offline
Well, I can give that a try. Is this some sort of keyboard shortcut for something?
QUOTE Thanks
cradom

 
cradom's Avatar
 
Member Since: Feb 14, 2004
Location: Nederland, Texas
Posts: 3,203
cradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant future
Mac Specs: 21in iMac core2 Duo- 13in macbook - 10.9 on both

cradom is offline
It's an Excel shortcut. Changes numpad from input to directional and back.
This is so you don't have to remove your hand from the keypad.

Craig Domingue - resident redneck.
“Never argue with an idiot. He will only bring you down to his level and beat you with experience.”, George Carlin
QUOTE Thanks
toMACsh

 
toMACsh's Avatar
 
Member Since: Jul 30, 2009
Location: Wisconsin
Posts: 5,516
toMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to all
Mac Specs: Mac Mini Core 2 Duo

toMACsh is offline
Quote:
Originally Posted by cradom View Post
Try pressing shift-clear, or shift-F14, depending on the keyboard.
Well I don't have a "clear" key or F14, but Shift-NumLock did the trick!

Now the real trick will be remembering that the next time it accidently gets switched a year or two from now.

Thanks for the inspiration!
QUOTE Thanks
cradom

 
cradom's Avatar
 
Member Since: Feb 14, 2004
Location: Nederland, Texas
Posts: 3,203
cradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant futurecradom has a brilliant future
Mac Specs: 21in iMac core2 Duo- 13in macbook - 10.9 on both

cradom is offline
Glad you got it. Must be using an older keyboard? On my old Macally Numlock/Clear is the same key and is marked as such.

Craig Domingue - resident redneck.
“Never argue with an idiot. He will only bring you down to his level and beat you with experience.”, George Carlin
QUOTE Thanks

Post Reply New Thread Subscribe


« Free Cad Viewer | Lost notes »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
iPhone 3g number problem? jaymd iPhone Hardware and Accessories 0 03-18-2009 09:29 AM
Faulty number pad on keyboard! johnnytentoes Apple Desktops 2 10-09-2008 06:05 PM
Weird problem with Macbook punjabi Apple Notebooks 3 09-23-2008 10:11 AM
number pad not working Greyspot Design Apple Desktops 1 01-29-2008 03:10 PM
Version number for Microsoft Excel abhishekdubey OS X - Apps and Games 1 07-13-2006 10:36 PM

All times are GMT -4. The time now is 02:54 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?