Skip to content
Lesson 2/7

Moving with the keyboard

Exercise 1 of 4

Click B2, then hold Shift and press ↓ twice to select the first three amounts.

About this lesson

In a long list, the keyboard is faster than the mouse. Shift extends a selection, Ctrl (Cmd on a Mac) with an arrow jumps to the end of the data, and F2 edits a cell.

In this lesson

  1. Click B2, then hold Shift and press ↓ twice to select the first three amounts.
  2. Click A2, then press Ctrl+↓ (Cmd+↓ on a Mac) to jump to the last order in the list.
  3. Click B2, then press Ctrl+Shift+↓ (Cmd+Shift+↓ on a Mac) to select every amount in one go.
  4. B5 should add all three prices, but its formula leaves out milk. Click B5, press F2 to edit it, add +B4 at the end and press Enter.

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Click a cell, or drag over a range. It is checked as soon as the selection is right.