Chapter 7 Use Alt for column widths, borders and view settings ・ MISSION 37

Mission 37: Finish for client submission (final mission)

📋 Mission list
FileHomeInsertPage LayoutFormulasDataReviewViewPress and release Alt for key hints.

Keycat

Make the headers bold, calculate the total in B7, apply all borders to the table, fit column widths, freeze the top row and hide gridlines. Use only the keyboard.

Keystrokes 0/ Best example: 22

Chapter 7 ・ MISSION 37

Finish for client submission (final mission)

Make the headers bold, calculate the total in B7, apply all borders to the table, fit column widths, freeze the top row and hide gridlines. Use only the keyboard.

Now
Goal

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

Shortcuts used in this mission

  1. CtrlShift→
  2. →CtrlB
  3. →CtrlEnd
  4. →Alt=
  5. →CtrlEnter
  6. →CtrlA
  7. →Alt
  8. →H
  9. →B
  10. →A
  11. →Alt
  12. →H
  13. →O
  14. →I
  15. →Alt
  16. →W
  17. →F
  18. →R
  19. →Alt
  20. →W
  21. →V
  22. →G

You combined the skills from these missions to turn raw data into a client-ready table using the keyboard.

This is an operation for the Windows version of Excel (the Mac version of Excel does not have ribbon key tips).

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.