What grouping columns does

Grouping columns in Google Sheets lets you collapse and expand related columns with a single click. When you group columns, a bracket appears above them with a minus sign. Click the minus to hide those columns; click the plus to show them again. This is useful when you have many columns but only need to see some of them at once — for example, hiding all the detailed cost breakdowns while you review the final totals.

Grouping does not delete or move your data. It only hides columns temporarily. The data stays in place and reappears when you expand the group again. You can create multiple groups in the same sheet, and you can nest groups inside other groups if your data has layers of detail.

Key Takeaways

  • Select the columns you want to group by clicking the column letter of the first one, then holding Shift and clicking the last column letter in the range.
  • Open the Data menu, choose Group columns, and select the range you want to group — Google Sheets will create a collapsible bracket above your columns.
  • Click the minus sign in the bracket to hide the grouped columns; click the plus sign to show them again.
  • You can create multiple separate groups in the same sheet, and you can group columns within columns by grouping a subset of an already-grouped range.
  • To remove a group, select any column in that group, open Data, choose Ungroup columns, and confirm the range.

How to select the columns you want to group

Start by identifying which columns belong together. In Google Sheets, you select a range of columns by their letters — the A, B, C row at the very top of the sheet. Click on the letter of the first column in your group. The entire column highlights in blue.

Now hold down the Shift key on your keyboard and click on the letter of the last column you want to include. Google Sheets selects all the columns from the first one to the last one, including everything in between. For example, if you click on column D, then Shift-click on column G, columns D, E, F, and G all highlight. You do not need to select the rows — just the column letters.

If you want to group non-adjacent columns (columns that are not next to each other), you cannot do that with a single group. Google Sheets groups only continuous ranges. You would need to create separate groups for each range instead.

Creating the group through the Data menu

With your columns selected, look at the menu bar at the top of the sheet. Click on Data. A dropdown menu appears with several options. Find and click on Group columns. A small dialog box opens asking you to confirm the range you want to group.

The dialog shows the column letters of your selection — for example, "Columns D:G". If this is correct, click the Group button. Google Sheets creates a bracket above your selected columns with a minus sign inside it. The bracket appears in a gray bar above the column letters. Your columns are now grouped and ready to collapse.

If the range shown is not what you intended, click Cancel and start over with a different selection. You can always group again with a different set of columns.

Collapsing and expanding your grouped columns

Once a group exists, you will see a bracket with a minus sign (−) above the grouped columns. Click that minus sign, and the columns disappear from view. The minus sign changes to a plus sign (+), and a small number appears next to it — usually a 1 or 2, depending on how many levels of grouping you have.

Click the plus sign to expand the group and show the columns again. The plus changes back to a minus. You can collapse and expand as many times as you need. This does not affect your data at all — you are only changing what you see on screen.

If you have created multiple groups in the same sheet, each group has its own bracket and its own collapse button. You can collapse one group while leaving others expanded. The numbered buttons (1, 2, 3) on the left side of the bracket let you collapse or expand all groups at once — click 1 to show only the outermost data, click 2 to show one level of detail, and so on.

Creating nested groups for multi-level data

If your data has layers — for example, monthly columns grouped into quarters, which are grouped into years — you can create nested groups. Start by grouping your smallest units (the monthly columns). Then select a larger range that includes those columns plus others, and group that range too. Google Sheets stacks the brackets and adds numbered buttons on the left.

When you have nested groups, the numbered buttons become very useful. Click the 1 button to collapse everything and see only the largest groups. Click the 2 button to expand one level and see the medium-sized groups. Click the 3 button to expand all the way and see every column. This lets you zoom in and out of your data without manually clicking each bracket.

Removing a group you no longer need

To delete a group, click on any column that is part of that group. You do not have to select the whole range — just one column inside it. Open the Data menu again and click Ungroup columns. A dialog appears asking which range you want to ungroup. It shows the columns in that group.

Click the Ungroup button to confirm. The bracket disappears, and all the columns in that group become visible again. Your data is unchanged — you are only removing the grouping structure. If you have nested groups and ungroup the outer group, the inner groups remain in place.

Frequently Asked Questions

Can I group rows instead of columns?

Yes. The process is identical: select the row numbers on the left side of the sheet instead of column letters, then go to Data and choose Group rows. The bracket appears to the left of your rows instead of above them.

What happens to my grouped columns when I share the sheet?

The groups stay in place. Anyone you share the sheet with sees the same brackets and can collapse and expand the groups themselves. Each person's view is independent — if one person collapses a group, it does not collapse for everyone else.

Can I group columns that are not next to each other?

No. Google Sheets groups only continuous ranges of columns. If you need to hide non-adjacent columns, you would create separate groups for each continuous range, or you could delete the columns you do not need and add them back later.

If I ungroup columns, do I lose any data?

No. Ungrouping only removes the bracket and collapse buttons. All your data remains exactly as it was. You can group the same columns again at any time.

How many levels of nested groups can I create?

Google Sheets supports up to eight levels of nesting. In practice, most sheets use two or three levels because more than that becomes hard to navigate.