Forum Discussion
Ctrl Shift Down key not working. Only Down.
hey there, I'm the author of this thread. So from what I discovered, apparently it's related to the keyboard itself. Apparently, some built-in block in its drivers or smth.
I confirmed that it's a keyboard issue, since I first used it on my home PC and what made me create this question.
I then found a new job where I didn't like the keyboard and I bought a new one for my home PC and brought my old one to the office.
When I plugged my old one to the work PC the issue appeared on it and when I bought a new one for my home, the issue disappeared on it.
So there you go. The anti-ctrl+shift+down keyboard I have is Thermaltake Challenger Prime RGB Gaming Keyboard from Thermaltake Challenger Prime RGB Gaming Keyboard and Mouse Combo
Does the down button not work separately either?
If not, change the keyboard.
If the separate key works, go to Tools - Options ... - Change the checkbox Alternative movement keys activated.
There must be no mark.
if it still doesn't work, please check whether the problem is only with this file.
Then one would have to dig deeper, whether maybe another program, which is open at the same time, leads to this problem.
If it does not work, please inform us so that we can follow up further steps together.
If it works, I would be happy to hear from you if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
All keys work fine as mentioned in my 1st post.
"Tools - Options ... - Change the checkbox Alternative movement keys activated."
Could you please clarify the full path to this option?
If you mean Options -> Advanced -> Lotus Comaptility at the bottom, that one is unchecked as I mentioned in my first post. Tried to bounce it as well, no effect.
CTRL + SHIFT + DOWN ARROW not selecting column of data
This is happening because of empty cells in the column where you are pressing Ctrl+Shift+Down arrow. If there are no blank rows and no blank columns in your dataset, then you may select the entire range by pressing Ctrl+A while on any cell in the range.
If you have entire blanks rows and/or columns and if your selection range is large, then you may minimize your effort on range selection by referring to my solution at this link - http://www.ashishmathur.com/select-a-large-data-set-which-has-blank-rows-and-columns-without-using-the-shift-and-arrow-keys/
Hope this helps.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
- Nope, the described there is not what I face.
Once again:
1. no blanks
2. no matter if it's a new file or existing sheet/workbook.
3. Ctrl+Down works fine.
4. Ctrl+Shift+Up/Left/Right works fine.
The workaround I have to use at the moment is Ctrl+Down to the last cell and then Ctrl+Shift+Up to the top cell to select them in a column.
I have tried all the ways but no luck.
1) Key board is perfectly working - in Excel / for other applications
2) Alternative movement keys - Unchecked (by default)
As a last attempt, try to renew all drivers from the manufacturer's side of the laptop,
Lenovo System Update: Update Drivers, BIOS and Applications
then a Windows update
...and if necessary, an Office repair.
Hope I could help you with these information / links.
NikolinoDE
I know I don't know anything (Socrates)
