Outlining · original practice scenario
Open the Ungroup row-or-column choice
Put sample records in B2:D6 and select the partial range C3:D5. First create a row group in the spare worksheet so there is an outline to remove.
Start here: A partial cell range is selected, not entire rows or columns
A whole-row or whole-column selection can execute grouping directly instead of opening this dialog. Grouping outlines is different from grouping worksheets.
Follow these instructions in your own desktop Excel workbook. This page explains the operation; it does not send commands to Excel.
Mac keys and context
Cmd+Shift+J
Publisher-documented binding. Native desktop execution has not been tested.
Desktop key table and operation notes; reviewed 2026-10-18. Exceljet publisher reference ↗
Walk through the operation
- Confirm that complete row or column headers are not selected.
- Use the listed chord and inspect the Ungroup dialog before choosing an axis.
- Cancel this first attempt; repeat only when ready to choose the intended Rows or Columns option.
Instruction 1 of 3: Confirm that complete row or column headers are not selected.
Expected result: The Ungroup dialog requests an axis; merely opening and cancelling it leaves the worksheet unchanged.
Recall the keys
Which listed Mac combination or sequence starts this operation in the context above?
Related walkthroughs
Browse all shortcut references →Catalog updated 2026-10-18. US keyboard notation: + joins held keys; commas separate successive presses. Function keys may require Fn. Desktop instructions are separate from this browser's own keyboard shortcuts.