# How to Group Columns Next to Each Other in Excel (2 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

In this article, we will learn to group columns next to each other in Excel. Unfortunately, you canâ€™t start a new group right next to another group of columns. Excel will combine the new group of columns with the previous one automatically. To overcome this, we will use an effective technique in todayâ€™s article. After reading the article, you will also be able to group columns next to each other in Excel. But for that to happen, you need to go through the whole article. So, without any delay, letâ€™s start the discussion.

## How to Group Columns Next to Each Other in Excel: 2 Easy Ways

To explain the article, we will use a dataset that contains information about the Sales Amount for the first five months of some sellers. In our dataset, we have 6 columns. We will try to group Columns C & D first and then, group Columns E & F next to the previous one.

### 1. Use Keyboard Shortcuts to Group Excel Columns Next to Each Other

In the first method, we will use the keyboard shortcuts to group columns next to each other in Excel. In Microsoft Excel, most of the commands can be implemented with keyboard shortcuts. As we stated in the introduction, you canâ€™t group columns next to each other but you can use some tricks here. The tricks are to insert a new column and decrease the column width according to your preference.

Here, we will group Columns C & D first and then, group Columns E & F next to the previous one.

Letâ€™s pay attention to the steps now and see what we need to do to group adjacent columns.

STEPS:

• First of all, you have to insert a new column between Group â€“ 1 & Group â€“ 2.
• That means you need to select the first column of Group â€“ 2.
• In our case, Columns C & D form Group â€“ 1, and Columns E & F form Group â€“ 2.
• That is why we have selected Column E.

• Secondly, right-click on Column E.
• It will open the Context Menu.
• Select Insert from there.

• After selecting Insert, the dataset will look like the picture below.

• Thirdly, select the first column of Group â€“ 1.
• In our case, that is Column C (in the updated dataset after inserting a new column).

• Now, press Alt + Shift + Right Arrow on the keyboard.
• A negative (â€“) sign will appear.
• Then, select Column D.
• Again, press Alt + Shift + Right ArrowÂ together.

• It will group Columns C & D. You can see that in the picture below.

• You can press the negative (â€“) sign to hide the grouped columns.
• After pressing the negative (â€“) sign, a plus (+) sign will appear.
• You can unhide the grouped columns using the plus (+) sign.

• In the following step, select Column F.

• Press Alt + Shift + Right Arrow keys together.
• Next, select Column G.
• Once again, hit the Alt + Shift + Right Arrow keys on the keyboard.

• After completing the previous steps, you will see grouped columns like below.

• Finally, decrease the column width to show the groups next to each other.

### 2. Group Columns Next to Each Other from Data Tab in Excel

We can also group columns next to each other from the Data tab in Excel. This process is quite similar to the previous one. But we will use the Data tab instead of keyboard shortcuts here. So, without further ado, letâ€™s follow the steps below.

STEPS:

• In the first place, select Column E and rightâ€“click on the mouse.
• It will open the Context Menu.
• Select Insert from there.

• After that, select Cell C6 & D6.
• We have selected these two cells because we want to group Columns C & D.
• You can select any two adjacent cells from the desired columns.
• For example, if you want to group Columns M, N, and O then, you can select Cells M1, N1, and O1Â together.

• In the following step, go to the Data tab and select the GroupÂ icon.

• A message will pop up.
• Select Columns and click on OK.

• After clicking OK, Columns C & D will be grouped.

• In the next step, select Cell F6 & G6 to group Columns F & G.

• Then, navigate to the Data tab and select the Grouped.
• Instantly, you will see results like the screenshot below.

• In the end, decrease the column width of Column E.

## How to Ungroup Columns Next to Each Other in Excel

In this section, we will discuss the steps to ungroup columns next to each other in Excel. You can use the same procedure to ungroup rows in Excel. Now, follow the steps below to know more about the method.

STEPS:

• Firstly, select adjacent cells of the grouped columns.
• We have selected Cell C6 and D6.

• Secondly, click on the Data tab in the ribbon.
• Then, select the UngroupÂ icon.

• A message box will occur.
• Select Columns and click OK.
• To ungroup rows, you need to select Rows in this step.

• Finally, Columns C & D will be ungrouped.
• You can repeat the same steps to ungroup Columns F & G.

## Things to Remember

It is better to remember a few things while you are trying to group columns next to each other in Excel.

• In Microsoft Excel, you canâ€™t create two separate groups right next to each other. It is a limitation of Excel.
• You need to press the Alt + Shift + Right Arrow every time you want to add a column to the existing group.
• In Method-2, donâ€™t use the Ctrl key to select multiple columns at a time. Instead, use the mouse to select adjacent cells of the desired columns.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mursalin Ibne Salehin

Hi there! This is Mursalin. I am currently working as a Team Leader at ExcelDemy. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I manage and help the writers to develop quality content in Excel and VBA-related topics.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF