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

Mission 38: Group and collapse details

📋 Mission list

Keycat

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

FileHomeInsertPage LayoutFormulasDataReviewViewPress and release Alt for key hints.
Keystrokes 0/ Best example: 9

Chapter 7 ・ MISSION 38

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.

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