How To Group Columns In Google Sheets

In this tutorial, you will learn how to group columns in Google Sheets.

Google Sheets has a tool called “Group” that groups two or more rows or columns. The user can choose to minimize or maximize the grouped data while grouping. When decreasing or maximizing, the group’s rows or columns contract and enlarge respectively.

Once ready, we’ll get started by utilizing real-world examples to show you how to group columns in Google Sheets.

Group Column

Before we begin we will need a group of data to be used to group columns.

Step 1

Make sure your group of data is displayed in a clean and tidy manner. This will help us to group columns easily.

Step 2

To group columns B to E, right-click, click View more column actions, then select Group columns B-E.

Step 3

Once grouped, you will see a minimized line on top of the columns.

Step 4

Once you minimize the columns, your Google Sheets will look like this.


That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to group columns in google sheets. Want more? Check out all the Google Sheets Tutorials.