End, Left Arrow: Move to Left Nonblank Cell

The shortcut End, Left Arrow is to move to the last left nonblank cell if the cells are not blank; or to move to the last cell with data in the row if the cells are blank.

Step 1: Click any cell on the right of the data range;

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

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

Step 4: When the cursor is on the left edge of the current data range, the cursor will move to the first column.

Check More Excel Shortcuts

Leave a Reply