Excel shortcuts

How to Use Keyboard Shortcuts to Group Data in Excel

If you work with data in Excel, you know how important it is to be able to group and Ungroup data quickly and easily. This can be done with a few simple keyboard shortcuts.

To Group data in Excel:

  1. Select the data you want to group.
  2. Press Ctrl+Shift+& (the ampersand key).
  3. Click the Group button in the Data tab of the Ribbon.

To Ungroup data in Excel:

  1. Select the data you want to Ungroup.
  2. Press Ctrl+Shift+U (the letter "U" key).
  3. Click the Ungroup button in the Data tab of the Ribbon.

With these keyboard shortcuts, you can quickly and easily group and Ungroup data in Excel.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.