The shortcut Ctrl+Shift+Up Arrow is to extend the selection to the first nonblank cell in the column, or to the next nonblank cell if the next cell is blank.
1. Extend the selection to the first nonblank cell in the same column: When the cursor is below the data range, the shortcut will select the cells to the first nonblank cell in the worksheet.
Step 1: Click anywhere in the worksheet, e.g., cell B8;
Step 2: Press and hold the "Ctrl" key and the "Shift" key, then press the "Up Arrow" key.
2. Extend the selection to the next nonblank cell: When the cursor is in the data range, the shortcut will select to the top edge of the data range.
Step 1: Click anywhere in the worksheet, e.g., cell B5;
Step 2: Press and hold the "Ctrl" key and the "Shift" key, then press the "Up Arrow" key.
