End, Down Arrow: Move to Bottom Nonblank Cell

The shortcut End, Down Arrow is to move to the bottom nonblank cell if the cells are not blank; or to move to the first cell with data in the column if the cells are blank.

Step 1: Click any cell above the data range;

Step 2: Press the "End" key from the keyboard, and press the "Down Arrow". The cursor will move to the top edge of the data range in the column;

Step 3: When the cursor is in the data range, the cursor moves to the last cell in the data range;

Step 4: When the cursor is in the last row of the current data range or in a blank cell, the cursor moves to the last cell of the column.

Check More Excel Shortcuts

Leave a Reply