The shortcut Shift+Up Arrow is to extend the selection by one cell up.
Step 1: Click anywhere in a worksheet, e.g., C5;
Step 2: Press and hold the "Shfit" key from the keyboard, then click the "Up Arrow". You will find you have selected cell C5 and cell C4.
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.
