Forum Discussion
Down arrow in Excel
I have a desktop computer which I'm having a problem with. I type 123 in one cell and get different results when I hit the down arrow to input the next number. I thought that the key pad had gone bad so I bought a new one, hooked it up and had the same problem. I opened a laptop on the same network, accessed the same worksheet and everything worked fine.
Is the problem in the keyboard, the computer or the software, and how do I fix it?
| 12322 | Typed 123 and hit down arrow twice B4 highlighted box moved | ||||||
| 1232 | Typed 123 and hit down arrow once B4 highlighted box moved | ||||||
| 123 | Typed 123 and hit down arrow, highlighted box moved correctly | ||||||
| 1 | Typed 123 and hit down arrow, highlighted box apparently moved on 2 | ||||||
| 3 | Result of above | ||||||
| 1 | Typed 123 and hit down arrow, highlighted box apparently moved on 2 | ||||||
| 3 | Result of above | ||||||
| 12322 | Typed 123 and hit down arrow twice B4 highlighted box moved | ||||||
| 1 | Typed 123 and hit down arrow, highlighted box apparently moved on 2 | ||||||
| 3 | Result of above | ||||||
| 123 | Typed 123 enter and hit down arrow, highlighted box moved correctly | ||||||
| 1 | Typed 123 enter and hit down arrow, highlighted box moved on 2 | ||||||
| 3 | Result of above | ||||||
| 1 | Typed 123 enter and hit down arrow, highlighted box moved on 2 | ||||||
| 3 | Result of above | ||||||
| Left, right and up arrows all appear to operate correctly. | |||||||
Hi Chris.
That is odd. Sounds like a software issue on your install of Office
What version of Excel do you have?
Is it on Office 365?
If it is then if you search for Add/Remove programs then find office and try a quick repair.
If that doesn't work try the full online repair option
Hi Chris.
That is odd. Sounds like a software issue on your install of Office
What version of Excel do you have?
Is it on Office 365?
If it is then if you search for Add/Remove programs then find office and try a quick repair.
If that doesn't work try the full online repair option
- Hi Wyn, I appreciate your help on my odd problem. You are correct, Excel 2016 which is part of Office 365. I tried the quick repair, and that didn't work, so I tried the online repair with no better results. Do you have any other suggestions?
- If you go into FIle > Account can you tell me what version you are on.
It should say something like Semi Annual Channel
Build 1706.123.456
Also go to File > Feedback > Send a frown to report this.
Final thought, what language/keyboard settings do you have on. Do a search in the windows search box for keyboard settingsVersion 1802 (Build 9029.2167)
sent frown
Not sure what your looking for in language/keyboard settings.
Can you please check if the
Sticky Keys are not turned on. plz see the screenshot.
go to search box and type Ease of access keyboard setting
- Jamil,
I appreciate your help in trying to fix my problem.
Although I'm not sure which search box you were referring to, I pressed Shift key 5 times and a pop-up screen came up that asked if I wanted to turn ON sticky keys. That to me indicated that sticky keys were OFF.- Can you please confirm whether you use numeric key pad in your keyboard when entering these numbers?
Can you please also check if keyboard key for Numlock is not pressed/stuck.
can you open a blank workbook and then post its screenshot here?
