Excel Shortcut to Group or Ungroup Rows and Columns

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on October 19, 2023

This article will demonstrate the shortcuts to group and ungroup rows and columns in Excel.

Group / Ungroup Rows and Columns

  • Grouping is used in Excel to group columns/rows together to minimize and maximize the data.
  • This is helpful when organizing a large dataset with many rows & columns
  • The example below shows the grouped data minimized to show yearly totals.

Grouping and Ungrouping Rows and Columns

Group Columns/Rows

  1. Highlight cells to group (Columns or Rows)

Highlight Columns to group

  1. Use this shortcut:
    PC Shortcut:ALT+Shift+
    Mac Shortcut:++K

Group Columns

Ungroup Columns/Rows

  1. Highlight cells to group (Columns or Rows)

Highlight Columns to Ungroup

  1. Use shortcut:
PC Shortcut:ALT+Shift+
Mac Shortcut:++J

Ungroup Columns

AI Formula Generator

Try for Free