![]() ![]() 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. Users often find that Ctrl Down key function stops at an intermediate cell and does not navigate up to the bottom of the sheet. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |