Shift+Right Arrow: Extends Selection One Cell Right

The shortcut Shift+Right Arrow is to extend the selection by one cell right.

Step 1: Click anywhere in a worksheet, e.g., C5;

Step 2: Press and hold the "Shfit" key from the keyboard, then click the "Right Arrow". You will find you have selected cell C5 and cell D5.

If you want to extend the selection to the end or the first cell in the same row or column, you may refer to the shortcut "Ctrl+Shift+Arrow" as below:

Ctrl+Shift+Left Arrow: Select the cell and all the cells in front of the cell in the same row;

Ctrl+Shift+Right Arrow: Select the cell and all the cells after the cell in the same row;

Ctrl+Shift+Up Arrow: Select the cell and all the cells above the cell in the same column;

Ctrl+Shift+Down Arrow: Select the cell and all the cells below the cell in the same column.

Leave a Reply