Chapter 5 Combined practice: add, organise and summarise data ・ MISSION 22

Mission 22: Create a total row to make it stand out

📋 Mission list

Keycat

Calculate the total in B7, then make all of row 7 bold.

Keystrokes 0/ Best example: 5

Chapter 5 ・ MISSION 22

Create a total row to make it stand out

Calculate the total in B7, then make all of row 7 bold.

Now
Goal

The tutorial is On. You can change this setting on the mission list page. Mission list

Shortcuts used in this mission

  1. CtrlEnd
  2. →Alt=
  3. →CtrlEnter
  4. →ShiftSpace
  5. →CtrlB

Hit Ctrl+End to the bottom right of the table. If you confirm with Ctrl+Enter, the cell will not move, so you can continue to manipulate that row.

On Mac, use ⌘ (command) instead of Ctrl (control for date, currency display, etc.).

Practise individual shortcuts or check the shortcut reference here. Shortcut drillsExcel shortcut list

Use the keys shown in this simulator. In Excel itself, ribbon letters and some shortcuts differ by language and keyboard layout.