Wauvel

Excel like a finance pro.

← The library

Rows & columns shortcut

Ungroup the selected rows or columns

Alt + Shift + ← on Windows, ⌘ + Shift + J on Mac.

OccasionalDifficulty 1100 · Proficient
Practice · 2 questions →

When to use it

Removes the outline group from the selected rows or columns.

The shape of it

Windows
Alt + Shift + ←
Mac
⌘ + Shift + J

Worked examples

  • Ungroup rows

    Select the grouped rows, Alt + Shift + ← → The bracket disappears, rows stay visible

    Ungroup.

  • Ungroup columns

    Select grouped columns, Alt + Shift + ← → Ungrouped

    Same for columns.

  • Clear all groups

    Data, Ungroup, Clear Outline → Every group removed at once

    Start over.

Worth knowing

  • Expand the group before ungrouping or the rows stay hidden.
  • Ungrouping the outer level of nested groups leaves the inner ones.
  • Clear Outline is faster for many groups.

Where it goes wrong

  • Rows hidden by a collapsed group remain hidden after ungrouping; unhide them.
  • Selection must cover the whole group.

Related

Ctrl + Shift + +Ctrl + -Alt, H, O, ICtrl + 9Ctrl + 0Alt + Shift + →

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.