End, Right Arrow: Move to Right Nonblank Cell

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

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

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

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

Step 4: When the cursor is in the last column of the current data range, the cursor moves to the last cell of the worksheet.

Check More Excel Shortcuts

Leave a Reply