Google Sheets Beginners – Change Your Current Workbook’s Timezone Date & Currency (16)

Google Sheets

As we increasingly start to work from home and work with clients globally, it is vital that we prepare our Google Sheet for the country that our users and clients are from.

In this tutorial, we will cover how to quickly change your current Google Sheet’s timezone, date and currency for the entire document.

In this tutorial, I’ll cover,

Continue reading “Google Sheets Beginners – Change Your Current Workbook’s Timezone Date & Currency (16)”

Google Sheets Beginners: Insert Columns and Rows (12)

Google Sheets: Insert and Shift Columns and Row

Even if you are a veteran Google Sheets users you might find a great little tip in this tutorial.

Here we will cover how to insert columns and rows in Google Sheets spreadsheets. Oh, and how to cheat at connect 4.

In this tutorial, I’ll cover,

  1. Inserting columns and sheets from the menu bar.
  2. Insert columns and sheets by right-clicking cells and row and columns references.
  3. Inserting multiple columns and rows at one time.
  4. Shifting a cell set up, down left and right by one or many cells.
Watch this video on YouTube.

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*

~Yagi

*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: Freeze Rows and Columns(11)

Google Sheets: Freeze

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:

  1. What Freeze does in a Google Sheets spreadsheet.
  2. How to freeze single or multiple columns and rows by using the menu bar.
  3. How to freeze using right-click on columns and cells.
  4. Some common issues you may face with freeze.
Watch this video on YouTube.

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*

~Yagi

*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: Paint Format (10)

Google Sheets: Paint Format

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.

Google Sheets Paint Format button

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.

Check out the video below:

Watch this video on YouTube.

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*

~Yagi

*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: Borders (07 & 08)

In this next part of our Google Sheets Beginners Youtube course, we take a look at borders. Borders can provide a huge boost to the readability of both your digital Google Sheet and your printed spreadsheets. Not only that, but careful use of border styles, weight and colour can help guide your reader to the most important bits of information on your spreadsheet.

These tutorials are for the Google Sheet or even spreadsheet beginner. I’ve broken the border tutorial down into two parts:

Google Sheets Border Basics

In this tutorial, I’ll cover,

  1. How to add borders to a range specifying what part of the range the border will be.
  2. Adding colour to your borders.
  3. Adding border thickness or dashes and dotted borders.
  4. Troubleshooting a few issues you might face when creating multiple border types.
Watch this video on YouTube.

A Borders Style and Usage Guide

In this tutorial, I’ll cover,
1. Fast workflow for styling borders in a larger “real” project.
2. Using borders to attract the user to important pieces of information.
3. Show common mistakes to watch out for in workflow.

Watch this video on YouTube.

Can you think of any other great ideas for using borders in Google Sheets? I love to hear them. Feel free to add your thoughts in the comments below.

Keep an eye out for more Google Sheets basics tutorials. You can even subscribe! Top right!

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.