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!

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

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
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.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

Google Sheets Beginners: Cutting, Copying and Pasting ( + bonus complete guide) (35)

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,

  1. 00:00 Intro
  2. 00:30 The basic copy and paste function and it’s shortcuts.
  3. 01:59 Copy and pasting basic formatting.
  4. 02:38 Differences with formulas with copy and paste.
  5. 04:01 Copy and pasting – across select ranges in the same Sheet.
  6. 04:43 Copy and pasting – from one Google Sheet to another.
  7. 05:38 Copy and pasting – from a different Google Sheet to another.
  8. 06:19 Copy and pasting – from other document types like Text, Excel, or a Webpage.
  9. 10:15 Copy and pasting – same values or a range of values multiple times.
  10. 11:57 Copy and pasting – formatting only.
  11. 13:12 How copying the formatting also copies conditional formatting.
  12. 13:55 Copy and pasting – excluding borders.
  13. 14:36 Copy and pasting – column widths only.
  14. 15:40 Copy and pasting – formulas only.
  15. 16:44 Copy and pasting – data validation
  16. 17:27 Copy and pasting – conditional formatting only.
  17. 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 Shorts: Beginners

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
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.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

Google Sheets Beginners: Split text to columns (33)

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 Shorts: Beginners

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
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.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

Google Sheets Beginners: Accessing the Keyboard Shortcuts (32)

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:

5 Easy Shortcuts That Will Save you Heaps of Time – Google Sheets

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

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
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.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

Google Sheets Beginners: Editing Excel and ODS format files in Google Sheets (31)

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,

  1. How to upload an Excel sheet to your Google Drive 00:16
  2. Adding an Excel file from your email 01:04
  3. Directly editing an Excel sheet from your email 01:25
  4. How do I know if it’s an Excel, ODS, or Google Sheet? 01:34
  5. Differences in Google Sheets from your Excel sheet 02:07
  6. Benefits of editing in Google Sheets to transfer easily. 02:55
  7. Where has my edited/ opened Excel sheet gone? 03:12
  8. Downloading your file from Google Drive 03:47
  9. Comparisons in sheets, from your Drive to Excel 04:17
  10. A different way to download 05:01
  11. Converting Excel to Google Sheets. 05:17

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

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
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.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

%d bloggers like this: