How To Group Columns In Google Sheets

Last Updated on October 30, 2023 by Jake Sheridan

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

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.

Grouping Columns in Google Sheets (4 Simple Steps)

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.

Further reading: How To Group Rows In Google Sheets


That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. 

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.