Excel shortcuts

How to create a group shortcut in Excel

If you work with large amounts of data in Microsoft Excel, you may find yourself in need of a way to quickly and easily group data together. One way to do this is to create a group shortcut. This will allow you to select a range of cells and then quickly group them together without having to use the mouse. Here's how:

  1. First, select the range of cells that you want to group together. You can do this by clicking and dragging your mouse over the cells, or by using the keyboard shortcuts Shift+Arrow keys to select a range.
  2. Once the cells are selected, press the Alt+Shift+G keys on your keyboard. This will open the Group dialog box.
  3. In the Group dialog box, select the options that you want, such as whether you want to create a new group or add the selected cells to an existing group. You can also choose to show or hide the detail for the group.
  4. Click OK to close the dialog box and group the cells together.

You can now collapse or expand the group by clicking on the +/- symbols next to the group. This can be a great way to quickly organize and view your 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.