Step 4 – Now press Ctrl+Shift+Down to select all the cells up to the bottom (up to the row which you selected in Step 2) 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 Shift Down key function stops at an intermediate cell and does not select all cells up to the bottom.
