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!
This tutorial covers:
00:28 Example of grouped data
01:44 How column and row groupings work.
02:52 How to create groupings in Google Sheets
02:59 Grouping columns
04:03 Grouping adjacent columns and rows
05:13 undo grouping
05:38 Grouping rows
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:
Have you ever wanted to lock those pesky rows of headers or columns so that when you scroll the titles are still there? In Google Sheets, this is done easily.
You can either got to View > Freeze and select your preferred depth of freeze. Or you can do my favourite approach, click and drag that thick line just above and to the left of cell A1 and drag it to your preferred location.
Easy as that.
Check out the video tutorial below for more tricks on using Freeze in Google Sheets. It will cover:
What Freeze does in a Google Sheets spreadsheet.
How to freeze single or multiple columns and rows by using the menu bar.
How to freeze using right-click on columns and cells.
Want to know a quick way to update a cell or range with an already existing format in your Google Sheets? Paint Format is here to the rescue.
This versatile tool will help you to quickly replicate font, alignment, border, rotation and other styling formats in your Google Sheet.
In this tutorial, I’ll cover,
1. What the Paint Format button is and what it does.
2. Formatting one cell to another.
3. What things Paint Format will format across.
4. Using the formatting from one cell to update many cells.
5. Formatting from multiple cells to multiple cells
6. What Paint Format won’t copy across.