Starting to select rows and columns of Excel data: “Shift” with ↑, ↓, →, ←
On your keyboard if you press “Shift” and at the same time press one of your e.g. up or down arrows, you’ll find you have a shortcut which helps you select Excel data. For example, pressing “Shift” followed by your down arrow ↓ acts as a keyboard shortcut for starting to select data within an Excel column. If, with Excel column data selected, you go on to press “Shift” and the right arrow → you will find that you have a shortcut which helps you start to select a block of data with your keyboard.
Keyboard shortcut for quickly selecting a block Excel data: “Ctrl Shift” with ↑, ↓, →, ←
If you preface the previous keyboard shortcut with “Ctrl” you will find that you can select a block of Excel data very quickly (rather than step by step). For example, pressing “Ctrl Shift ↓” is a keyboard shortcut for selecting a vertical block of Excel data. If you then press “Ctrl Shift →” you’ll have discovered a keyboard shortcut that allows you to select a whole block of Excel data very quickly.
Keyboard shortcuts for selecting a whole row or column of Excel data
Pressing “Ctrl” and “Space bar” at the same time on your keyboard provides you with a shortcut that selects a whole column within Excel.
Pressing “Shift” followed by “Space bar” (at the same time) acts as a keyboard shortcut for selecting a whole row of Excel data.
Deselecting data and returning to the active Excel cell: “Shift Backspace”
If you press “Shift” followed by “Backspace” at the same time on your keyboard, you have a shortcut for deselecting Excel data and returning to the active cell.
Insert/ delete Excel keyboard shortcuts