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
- Click
B2, then hold Shift and press ↓ twice to select the first three amounts. - Click
A2, then press Ctrl+↓ (Cmd+↓ on a Mac) to jump to the last order in the list. - Click
B2, then press Ctrl+Shift+↓ (Cmd+Shift+↓ on a Mac) to select every amount in one go. B5should add all three prices, but its formula leaves out milk. ClickB5, press F2 to edit it, add+B4at 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.