Excel shortcuts

Learn how to group columns in excel using this simple shortcut

If you work with large amounts of data in Microsoft Excel, you know how important it is to be able to organize that data in a way that makes sense. One way to do that is to group columns together so that you can more easily see and work with related data. Here's a quick tip on how to do that.

To group columns together, first select the columns that you want to group. You can do this by clicking on the column header of the first column you want to select, then holding down the Shift key and clicking on the column header of the last column you want to select. All of the columns in between will be selected as well.

Once you have the columns selected, right-click on one of the column headers and select "Group" from the menu that appears. Excel will then create a new outline level that you can expand or collapse just like any other outline level in Excel.

You can also group rows together in a similar way. Just select the rows you want to group, right-click on one of the row headers, and select "Group" from the menu. Excel will create a new outline level for the rows that you can expand or collapse just like any other outline level in Excel.

If you want to ungroup columns or rows, just select the columns or rows that you want to ungroup, right-click on one of the column or row headers, and select "Ungroup" from the menu. Excel will then remove the outline level that was created when you grouped the columns or rows.

That's all there is to it! Grouping columns and rows together is a great way to organize your data in Excel so that you can more easily see and work with related data. Give it a try the next time you are working with large amounts of 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.