How to Group Cells in Excel - A Step by Step Guide

Excel can be a powerful tool for managing and analyzing data, but it can also be overwhelming for new users. One of the most common tasks in Excel is grouping cells, which can help you organize and analyze data in a more efficient way. In this article, I will show you how to group cells in Excel in a few easy steps.

Step 1: Select the cells you want to group

The first step is to select the cells you want to group. You can do this by clicking on the first cell you want to include in the group, and then dragging your mouse over the rest of the cells. Alternatively, you can hold down the Shift key and select a range of cells, or you can hold down the Ctrl key and select individual cells.

Step 2: Click on the "Group" button

Once you have selected the cells you want to group, click on the "Group" button, which can be found in the "Data" tab, under the "Outline" section. You can also use the keyboard shortcut "Ctrl + Shift + G" to group the cells.

Step 3: Customize the group settings

By default, Excel will group the cells together and collapse them into a single row or column. However, you can customize the way the cells are grouped by right-clicking on the group and selecting "Group" from the drop-down menu. This will open up the "Grouping" dialog box, where you can set the options for grouping, such as hiding or showing the group outline, and whether to create summary rows or columns.

Step 4: Ungroup the cells

If you want to ungroup the cells, simply select the group, and then click on the "Ungroup" button, which can be found in the same location as the "Group" button.

Additional tips

Here are some additional tips to help you make the most of Excel's grouping feature:

  • You can group both rows and columns in Excel, depending on your needs.
  • You can use grouping to analyze data in pivot tables, by grouping values in the row or column labels.
  • If you have multiple levels of grouping, you can collapse or expand them by clicking on the plus or minus sign next to the group.
  • When you group cells, Excel will automatically add a group outline, which you can use to navigate through the grouped cells.


Grouping cells in Excel can be a useful tool for managing and analyzing data. With just a few simple steps, you can group your cells and customize the way they are displayed. Whether you are a beginner or an experienced Excel user, grouping can help you save time and stay organized.

By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.