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:00 Intro
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:
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Just when you thought that copy and paste was a no-brainer you start working in Google Sheets spreadsheets and find that there is a little more here than meets the eye.
The good news is that Google Sheets has some great pasting types to help you copy or cut your data and put it in the cells or ranges exactly how you want it.
This tutorial takes you through a simple beginners tutorial on copying and pasting in Google Sheets to rapidly get you underway and then we dive into a Complete Guide to cut, copy, all the various paste types and possible gotchas you might face.
Cut, Copy & Paste Basics
The most important takeaway from this tutorial are the shortcuts that are going to be vital for you to boost your efficiency:
Cut : PC – ctrl + X, Mac – ⌘ + X
Copy : PC – ctrl + C, Mac – ⌘ + C
Paste : PC – ctrl + V, Mac – ⌘ + V
Paste just the values : PC – ctrl + shift + V, Mac – ⌘ + shift + V
Cut, Copy & Paste Complete Guide
Here we dig into the weeds of all the capabilities that Google Sheets has with Cut, Copy and Paste.
In this tutorial, I’ll cover,
00:00 Intro
00:30 The basic copy and paste function and it’s shortcuts.
01:59 Copy and pasting basic formatting.
02:38 Differences with formulas with copy and paste.
04:01 Copy and pasting – across select ranges in the same Sheet.
04:43 Copy and pasting – from one Google Sheet to another.
05:38 Copy and pasting – from a different Google Sheet to another.
06:19 Copy and pasting – from other document types like Text, Excel, or a Webpage.
10:15 Copy and pasting – same values or a range of values multiple times.
11:57 Copy and pasting – formatting only.
13:12 How copying the formatting also copies conditional formatting.
13:55 Copy and pasting – excluding borders.
14:36 Copy and pasting – column widths only.
15:40 Copy and pasting – formulas only.
16:44 Copy and pasting – data validation
17:27 Copy and pasting – conditional formatting only.
18:40 Copy and pasting – transposed ( changing rows to columns and columns to rows)
Conclusion
So did anyone get the Tribble easter egg? Anyone…? 👓🐐
Spend some time masting the shortcuts for cut, copy and paste. Most of them will apply for all sorts of software (not just Google Products). So it is well worth knowing.
If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Have a list of names and need to separate the first and last name? Need to put a list of names in separate cells? Need to find a specific Sheet code in a website? Google Sheets has your back with Split text to columns.
In this tutorial, we quickly and easily cover how to do all these things to save you time and sanity.
If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Learning keyboard shortcuts are a must to improve performance when using Google Sheets.
Urban myth or not, I remember hearing a story about a manager in the financial industry who took away his new charge’s mouse and made sure the rest of the team didn’t give them one. This shocking bit of tough-love was to force their charge into using keyboard shortcuts because they knew that it dramatically improved their ability to quickly negotiate a spreadsheet.
I have been tempted to do this with my own staff over the years only, I suppose, tempered by the zeitgeist of this era.
In this short tutorial, we will cover how to access and negotiate the shortcuts menu so you can start to memorise the shortcuts you need to be successful as a Google Sheets ninja.
If you want a rundown on the top shortcuts to get you on the road to be the next Hussain Bolt of Google Sheets, check out the tutorial below:
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
You can now work on Excel and Open Document Format (ODS) file right in Google Sheets without converting the file to a Google Sheets file. This makes Googles Sheets a power collaboration tool.
In this tutorial, I’ll cover,
How to upload an Excel sheet to your Google Drive 00:16
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.