Selecting fast: Shift+Arrow, Ctrl+Shift+Arrow, whole rows and columns

In this lesson

1. 1. Select a few cells

   To select more than one cell, hold Shift and use the arrow keys.

   Each press adds one more cell.

2. 2. Select to the end

   Now add Ctrl. The selection goes all the way to the last filled cell.

   This is the fastest way to select a long column of numbers.

3. 3. Select a whole row

   Sometimes you need a full row, for example to delete it.

4. 4. Select a whole column

   You can select a full column in the same way.

5. 5. Try it yourself

   Use the keyboard only.

Part of Excel Essentials. Short lessons with practice in a real spreadsheet, checked as you go.