Selecting Excel data

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

Now we go on to look at Excel keyboard shortcuts that help you insert/ delete a row, column or cell. Alternatively, please click to return to our list of top Excel shortcuts.