Practise Excel shortcuts

Reading a shortcut is one thing, getting it into your fingers another. Press the shortcut and watch the sheet do what Excel does. Six short drills, a few minutes each.

  1. Jumping around your sheet

    No need to scroll down a long list. An arrow with the right key in front takes you straight to the edge of your data.

    7 steps
  2. Selecting

    Dragging the mouse over a hundred rows is fiddly. Hold Shift and the selection grows with every move.

    7 steps
  3. Copy, cut and paste

    The shortcuts you will use most. Undo belongs with them: trying is fine, you can always go back.

    7 steps
  4. Formatting

    Bold, italic and underlined without the ribbon. The same shortcut again turns it off.

    7 steps
  5. Entering and filling

    Edit a cell, fill a column and add up, without taking your hands off the keyboard.

    6 steps
  6. Filters and windows

    Filter buttons and the Find window come up with one shortcut, and close just as fast.

    6 steps