Chapter 6 Filter data, use absolute references and paste values ・ MISSION 32

Mission 32: Month-end close: add, total and report

📋 Mission list

Keycat

Enter the additional expense of 3000 in B6, change the total (B7) to the total of B2 to B6, and paste only that value in report column D7.

Keystrokes 0/ Best example: 15

Chapter 6 ・ MISSION 32

Month-end close: add, total and report

Enter the additional expense of 3000 in B6, change the total (B7) to the total of B2 to B6, and paste only that value in report column D7.

Now
Goal

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

Shortcuts used in this mission

  1. Ctrl↓
  2. →↓
  3. →3
  4. →0
  5. →0
  6. →0
  7. →Enter
  8. →Alt=
  9. →CtrlEnter
  10. →CtrlC
  11. →→
  12. →→
  13. →CtrlAltV
  14. →V
  15. →Enter

Add an expense, update the AutoSum range, and report the value. You have completed a typical month-end workflow without a mouse.

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.

* Some actions may not work depending on your browser environment (for example, shortcuts used by extensions).