Shift+Down Arrow: Extends Selection One Cell Down

The shortcut Shift+Down Arrow is to extend the selection by one cell down.

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

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

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