Ctrl+Shift+Home: Extends Selection to Beginning

The shortcut Ctrl+Shift+Home is to extend the selection of cells to the beginning of the worksheet.

Step 1: Click the last cell of the data range you need to select, e.g., B5;

Step 2: Press and hold the "Ctrl" and "Shift" keys, then press the "Home" key from the keyboard. You will see the data range A1:B5 is now selected.

Check More Excel Shortcuts

Leave a Reply