Ctrl+Left Arrow: Left Edge Current Data

The shortcut Ctrl+Left Arrow is to move to the left edge of the current data range, or the first column of the worksheet if the cursor is already on the left edge of the current data range. Please see more shortcuts with arrows.

1. When the cursor is right of the current data range

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

Step 2: Press the key "Ctrl" from the keyboard and hold it, then press the "Left Arrow" key;

The cursor will move to the right edge of the current data range.

2. When the cursor is anywhere in the data range

Step 1: Click any cell in the current data range;

Step 2: Press the Key "Ctrl" from the keyboard and hold it, then press the key "Left Arrow".

The cursor will move to the left edge of the current data range.

3. When the cursor is on the left edge of the data range

Step 1: Click any bottom cell in the current data range;

Step 2: Press the Key "Ctrl" from the keyboard and hold it, then press the key "Left Arrow".

The cursor will move to the first column of the current Worksheet.

Leave a Reply