How to group columns in Google Sheets and Excel

While working with a large dataset, it isn’t easy to scroll through the Sheets. Thankfully, Google Sheets and Excel allow one to easily group rows and Columns. This will enable one to expand and collapse columns and rows with a single click. This article will discuss ways of grouping columns in Google Sheets and Excel.

To group columns in Google Sheets

Methods that are used:

Keyboard shortcuts

Using the Group tool

Each of the above is discussed below:

Keyboard shortcuts

Steps to follow:

1. Visit the Google account and log in using your email detail (That is, https://www.google.com/account).

2. From the Google Apps, click on the Sheets icon and select the existing Sheet.

3. Highlight the column you want to group.

Note: The selected columns should not be empty. You can only group columns that contain data.

4. Press the ALT + SHIFT + RIGHT ARROW button on your keyboard.

5. The selected columns will be grouped.

Using the Group tool

Steps:

1. Visit the Google account and log in using your email detail (That is, https://www.google.com/account).

2. From the Google Apps, click on the Sheets icon and select the existing Sheet.

3. Highlight the column you want to group.

4. Click on the View tab on the menu. From the menu, hover the cursor over the Group button.


5. Choose the Group columns option.

6. The selected columns will be grouped.

To Ungroup columns in Google Sheets

Methods:

Keyboard shortcuts

Using the Group tool

Using the Group tool

Steps:

1. Visit the Google account and log in using your email detail (That is, https://www.google.com/account).

2. Highlight the column you want to ungroup.

3. Click on the View tab on the menu. From the menu, hover the cursor over the Group button.


4. Choose the Ungroup columns option.

5. The selected columns will be ungrouped.

Keyboard shortcuts

Steps to follow:

1. Visit the Google account and log in using your email detail (That is, https://www.google.com/account).

2. Highlight the column you want to ungroup.

3. Press the ALT + SHIFT + LEFT ARROW button on your keyboard.

4. The selected columns will be ungrouped.

To group columns In Excel

Methods that are used:

Keyboard shortcuts

Using the Group tool

Keyboard shortcuts

Here are the steps to follow:

1. Open the Excel application.

2. Highlight the column you want to group.

Note: The selected columns should not be empty. You can only group columns that contain data.

3. Then, ALT + SHIFT + RIGHT ARROW button.

Using the Group tool

Steps:

1. Open the Excel application.

2. Highlight the column you want to group.

3. Click on the Data tab on the menu, and locate the Outline section.

4. Click the Group button, and the selected columns will be ungrouped.

To ungroup in Excel

Using keyboard shortcuts

1. Open the Excel application.

2. Highlight the column you want to ungroup.

3. Press the ALT + SHIFT + LEFT ARROW button on your keyboard.

4. The selected columns will be ungrouped.

Using the Group tool

Steps:

1. Open the Excel application.

2. Highlight the column you want to ungroup.

3. Click on the Data tab on the menu, and locate the Outline section.

4. Click on the Ungroup button,

Leave a Comment