Google Sheets Beginners: Grouping Rows and Columns (36)

When your Google Sheet spreadsheet starts to grow in complexity it is often a good idea to group similar parts of your data so you can easily collapse and expand them as you need them. Fortunately, Google Sheets has your back with the Grouping tool.

In this tutorial, we will look at how to group rows and columns in Google Sheets. We’ll also look at a few advanced capabilities and show you how to avoid some common traps.

Check it out!

Watch this video on YouTube.

This tutorial covers:

  1. 00:00 Intro
  2. 00:28 Example of grouped data
  3. 01:44 How column and row groupings work.
  4. 02:52 How to create groupings in Google Sheets
  5. 02:59 Grouping columns
  6. 04:03 Grouping adjacent columns and rows
  7. 05:13 undo grouping
  8. 05:38 Grouping rows
  9. 06:27 Sub or secondary groupings.

If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:

Google Sheets Shorts: Beginners

Want a quick reference to the top shortcuts? Check out these handy mousepads.


Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*


*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.