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

Mission 36: Group and collapse details

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

Keycat

Group and collapse the detail rows, 2 through 6, leaving the subtotal visible.

Keystrokes 0/ Best example: 9

Chapter 7 ・ MISSION 36

Group and collapse details

Group and collapse the detail rows, 2 through 6, leaving the subtotal visible.

Now
Goal

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

Shortcuts used in this mission

  1. ShiftSpace
  2. →Shift↓
  3. →Shift↓
  4. →Shift↓
  5. →Shift↓
  6. →AltShift→
  7. →Alt
  8. →A
  9. →H

Shift+Alt+→ to group, Alt → A → H to collapse. Use when you want to show only the summary.

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.