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!

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

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.

Automatic download link for non-Google Workspace files in Google Drive

Ever wanted your users to simply click a button on your webpage and,💥, a file you saved on Google Drive is automatically downloaded for them?

Here have a look at two examples:

NOTE! Clicking the links above will automatically download the file described.

This quick tool allows you to do just that. It works with any file like:

  • Images e.g. *.png *.jpg.
  • Documents e.g. *.pdf *.doc.
  • Zip files e.g. *.zip *.7z.
  • Pretty much anything that isn’t a Google Workspace file like a Google Sheet, Google Doc, Google Slide.

Grab and set up the file

    1. Find the file you need to set up for auto-download.
    2. Righ-click the file.
    3. Select Get link.
    4. Ensure the settings says, Anyone with link can view.
    5. Select Copy link.
Google Drive get link example
Click to expand!

Create the link

*Wait for the converter to load.

Do no harm!

Yes, I guess this could be used for downloading some nefarious content. This little tool is designed to provide a convenience for you and the people you want to share your files with. Please consider other people when preparing a tool for them. Even a quick heads up in your own content might be a good idea:

  • Note! File will download automatically from Google Drive.
  • Note! Clicking this file will download it automatically.

What about my Google Workspace Files?

Not directly with this tool, I’m afraid. The simple answer is Google Workspace files are designed to be in Google Drive and online. Much better for you to share the file publically and then provide a link to the file.

However…

If you are intending on providing your Google Workspace files or folders for your users to download and use offline anyway then you could download the in advance. This will cause the Google Workspace files to be exported into an offline format. Then you can drag that converted file and put it back in your drive and share it. You will be able to complete the steps above then.

Also, if you are downloading an entire folder it will export it files into usually Microsoft formats for you automatically and save the entire document in a zip file. Then you can drag that zip file back into your Google Drive and convert with the above too.

Neat huh?

~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

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: You Can Create Custom Page Breaks for Printing and Exporting (30)

Yeap! That’s right. Google Sheets allows you to set custom page breaks for your Google Sheets tabs. So you can print exactly what you want on each page.

  1. What are custom page breaks? 00:00
  2. How custom page breaks work 00:30
  3. Turning custom page breaks off or on 00:58
  4. How to move custom page break lines 01:14
  5. Deleting a page break. 01:33
  6. Resetting all page breaks 02:08
  7. Saving or printing with your custom page breaks 02:28
  8. Removing portions/pages to print or save 03:13
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!

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.