End, Up Arrow: Move to Top Nonblank Cell

The shortcut End, Up Arrow is to move the cursor to the top nonblank cell if the cells are not blank; or to move to the last cell with data in the column if the cells are blank.

Step 1: Click any cell under the data range;

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

Step 3: When the cursor is in the data range, the cursor will move to the top edge of the current data range;

Step 4: When the cursor is on the top edge of the current data range, the cursor will move to the very top.

Check More Excel Shortcuts

Leave a Reply