Feb 07 2021 10:51 PM
Up/left/right work OK, Down - no reaction.
F8, Transition keys - all checked, all disabled.
All keys work fine separately. To select a column I now have to go down with Ctrl+Down and then up with Ctrl+Shift+Up.
Please advise.
Excel for Miscrosoft 365 MSO (16.0.13628.20234) 64 Bit.
P.S.
Inability to select and copy the version of an app is very not fun when your versions consist of 10+ digits.
Feb 07 2021 11:49 PM
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.
Feb 08 2021 12:55 AM
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.
Feb 08 2021 01:05 AM
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-t...
Hope this helps.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
Feb 08 2021 01:44 AM
Feb 08 2021 02:41 AM
Unfortunately, I cannot help you here.
I'm at the end of my Latin.
At the end I would like to ask again with your permission.
Are the files in the OneDrive?
Have you recently performed a windows update?
One last attempt, maybe it's the ScrLk button.
If your keyboard does not have a Scroll Lock key, on your computer, click Start> Settings> Ease of Access> Keyboard.
Click the On Screen Keyboard button to turn it on.
When the on-screen keyboard appears on your screen, click the ScrLk button.
Sorry that I took up your time without having submitted a concrete solution.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Feb 08 2021 03:06 AM
Does Ctrl+Shift+Down works in any other Office app? For example in Word it shall be selection till end of the paragraph.
If not, as variant some driver or app installed as a service could work with this shortcut and the block trigger for the Office apps.
Feb 08 2021 03:16 AM
Feb 08 2021 03:20 AM - edited Feb 08 2021 03:21 AM
Good point. In Word it doesn't work for down as well.
Yeah, I thought about possible service or driver issue, but the fun part is that the issue is active on 2 out of 3 PCs I have.
Old work business laptop (no issue), new work business laptop (issue present) and personal gaming PC (issue present).
Same keyboard for all three. Quite a different set of apps active on own and work PC.
There was an app that allowed to identify what hotkey is used by which process in W7.
Anything like that for W10?
Feb 08 2021 10:01 AM
In my experience I had only one case when Intel Graphics control panel eat some shortcut, but I don't remember which one exactly and exact name of the service.
Feb 08 2021 06:37 PM