
If the key combination is not at all working, try changing the settings by going to Excel Options> Advanced> Tools>Options>Uncheck Transition Navigation Keys.

Step 4 – Now press Ctrl+Down to navigate up to the bottom (up to the row which you selected in Step 2)Īnother problem with Ctrl+Down function is associated with Transition Navigation Keys. Excel fills in all blank cells with the value 0. Step 2 – Select the range of cells that you need to navigate. Step 1 – Before entering values in blank cells One solution to avoid this issue is to fill in the blank cells with value 0 (zero) if it doesn’t affect the purpose of the sheet. This is because it stops at the first blank cell in the column. That will be the final proof that is (or not) a software issue.Users often find that Ctrl Down key function stops at an intermediate cell and does not navigate up to the bottom of the sheet.



Let me tell you why I didn't took the efective path of test and fail: Uncle Ben wouldn't like to see you making fun of my arachno-injury.
