Report

Number pad not working in Excel [Solved/Closed]

Ask a question al - Last answered on Aug 7, 2017 at 12:11 PM by Ann
Hello,

i have an extended keyboard on a macbook pro and the number pad won't work. letters all work. num pad works fine everywhere else - word, safari, etc. just not in excel. a wireless targus keypad suddenly doesn't work any more either. targus says it never should have worked but it did for a few years. now nothing. there is no num lock on the keyboard and I tried all the 'f' keys. f14 is the scroll lock but no num lock.

any thoughts anyone?

See more 
Helpful
+52
plus moins
just found the answer. shift-clear (key above the 7) turns num lock on and off. who in the world would think of that???

btw, f14 is the scroll lock.

posting this in case others have the same problem.
Alog2- Mar 12, 2013 at 10:20 PM
thanks you're the man!
mac mini (mid2011)
ms excel 2011
A4tech usb keyboard ("A")
Landlock- Apr 4, 2013 at 02:06 AM
Fantastic. That worked for me too.
Grandmaster Hash- Apr 22, 2013 at 02:34 AM
Thanks buddy, that's been driving me mad for the last week!
Thankful Guy- May 29, 2017 at 08:55 AM
Still working now!

iMac / May 2017

Thanks a lot!
Reply
Ann- Aug 7, 2017 at 12:11 PM
Thank you!!! Who would have thought! Shift + Clear = Num Lock
Reply
Helpful
+11
plus moins
It solved my problem too! Thanks!

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!