Forum Discussion

nekku's avatar
nekku
Copper Contributor
Feb 08, 2021
Solved

Ctrl Shift Down key not working. Only Down.

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 ...
excel
  • nekku's avatar
    nekku
    Jun 11, 2022

    tsd2k22 

    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 https://www.umart.com.au/product/thermaltake-challenger-prime-rgb-gaming-keyboard-and-mouse-combo-35561

     

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Feb 08, 2021

nekku 

CTRL + SHIFT + DOWN ARROW not selecting column of data

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_windows8-mso_2010/ctrl-shift-down-arrow-not-selecting-column-of-data/370dd1a7-f527-43b7-9c6b-015520a14f36?page=2

 

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)

nekku's avatar
nekku
Copper Contributor
Feb 08, 2021
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.

Resources