How to Ungroup Columns in Google Sheets

Grouping columns in spreadsheet applications like Microsoft Excel provides you with a simple method to hide and unhide large groups of data at once.

A column grouping in Google Sheets indicated by a gray bar above the spreadsheet with a thing black line connecting all of the grouped columns. If you click on the “-” symbol on that line, you can hide all of the grouped columns. Alternatively, clicking on the “+” symbol when the columns are hidden will display them.

But if you discover that this column grouping is creating problems for your workflow, then you may wish to ungroup those columns. Fortunately this can be accomplished in a manner similar to how those columns were grouped initially.

How to Ungroup Google Sheets Columns

The steps in this article were performed in the desktop version of Google Chrome. These actions can also be completed in other desktop browsers like Firefox or Safari.

Step 1: Sign into Google Drive and open the Sheets file with the column grouping.

Step 2: Click and hold on the leftmost column letter in the grouping, then drag right to select the rest of the grouped columns.

select the grouped columns

Step 3: Right-click on one of the selected columns, then choose the Ungroup columns option.

how to ungroup columns in Google Sheets

If you have ungrouped all of the columns then the gray bar above the spreadsheet that previously displayed the grouping line will be gone. If that gray bar remains then there are still grouped columns in the spreadsheet.

See also

solveyourtech.com newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.