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. 

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

Watch this video on YouTube.

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.

Watch this video on YouTube.

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

Want to be a shortcut master? 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. 

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.

Watch this video on YouTube.

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 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!

If your work life is Google Sheets, then you really need to master
the shortcuts to improve your efficiency. One way to do this is by
having a handy cheat sheet at hand for you to quickly reference. The
problem is that cheatsheets go missing and get in the way, but not
mousepads. They are right there beside you. So I thought, what about
a mousepad with a cheat sheet on it. The design is what you see
below. Take a look! It’s well worth a buy and helps support me to
build more content for you.

 

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.

Watch this video on YouTube.

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

If your work life is Google Sheets, then you really need to master
the shortcuts to improve your efficiency. One way to do this is by
having a handy cheat sheet at hand for you to quickly reference. The
problem is that cheatsheets go missing and get in the way, but not
mousepads. They are right there beside you. So I thought, what about
a mousepad with a cheat sheet on it. The design is what you see
below. Take a look! It’s well worth a buy and helps support me to
build more content for you.

 

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.

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

If your work life is Google Sheets, then you really need to master
the shortcuts to improve your efficiency. One way to do this is by
having a handy cheat sheet at hand for you to quickly reference. The
problem is that cheatsheets go missing and get in the way, but not
mousepads. They are right there beside you. So I thought, what about
a mousepad with a cheat sheet on it. The design is what you see
below. Take a look! It’s well worth a buy and helps support me to
build more content for you.

 

 

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.