Excel shortcuts

The Best Shortcut for Grouping Columns in Excel

If you work with large data sets in Excel, you know how important it is to be able to quickly and easily group columns of data. There are a few different ways to group columns in Excel, but the best way is to use a shortcut. By using a shortcut, you can save time and avoid having to click through a bunch of menus.

To group columns in Excel, first select the columns you want to group. Then, press and hold the Ctrl key on your keyboard. While you are holding down the Ctrl key, click the column headers of the columns you want to group. Once you have selected all of the columns you want to group, release the Ctrl key.

Now, all of the selected columns will be grouped together. You can tell they are grouped because they will have a small blue bar next to the column header. If you want to ungroup the columns, simply click on the blue bar and the columns will be ungrouped.

That's all there is to it! This shortcut is the quickest and easiest way to group columns in Excel. Give it a try the next time you need to group columns of data.

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.