Google Sheets Beginners: Backgrounds (06)

New to Google Sheets and spreadsheets in general? Find out everything you need to know about inserting a background cell colour efficiently.

Changing cell colours in Google Sheets can really make your spreadsheets pop!

In this tutorial, I’ll cover,
1. How to insert a background into a single cell.
2. Inserting a background into a range of cells.
3. A brief style guide on best practices when using colour in Google Sheets.
4. An example of background colour formatting.

Even knowing the basics can really give you the edge and save you a heap of time in the workplace.

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*

 

*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: Merging Text (5)

Google Sheets: Merging Text

New to Google Sheets and spreadsheets in general? Find out everything you need to know about merging cells inside a cell efficiently. Merging cells can really increase your design game.

In this tutorial, I’ll cover,
1. Merging Across rows.
2. Merging Across columns.
3. Merging mixed ranges.
4. Highlight some things to watch out for.
5. Go over a quick example of usage.

Even knowing the basics can really give you the edge and save you a heap of time in the workplace.

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*

 

*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: Formatting Text Inside Cell (4)

Google Sheets: Text Formatting

In this tutorial, I am going to show you some tricks on how to format text inside cells that most spreadsheet users have no idea about.

If you are new to Google Sheets or just spreadsheets in general, then this is for you. In this tutorial, I’ll cover:

In this tutorial, I’ll cover:

  1. Formatting selected text in a cell.
  2. Returning to new lines within a cell.
  3. Changing the colour of selected text in a cell.

Even knowing the basics can really give you the edge and save you a heap of time in the workplace. Check out the video below!

Watch this video on YouTube.

Google Sheets Shorts: Text Formatting (3)

Google Sheets: Text Formatting

If you a new to Google Sheets or spreadsheets in general, this short video is for you!

We’ll go formatting text in Google Sheet. Including:

  • Shorts cuts to access bold, italic, underline and strikethrough.
  • Changing the font type.
  • Changing the font colour.
  • Changing the size of the font.

Then I’ll wrap everything up with a quick example of some style best practice.

Watch this video on YouTube.

Google Sheets Shorts: Sorting Data (1)

Google Sheets: sorting data. 

In this Google Sheet tutorial, we’ll go through the nuances of using sort. You’ll find out how to sort by the sheet tab and by a selected range. Then, we will show you how sort works with text numbers and a mix of the two before diving into how to sort by multiple columns.

If you are new to Google Sheets or spreadsheets in general. Skill up and get an advantage on your workmates and check out the video below.

If you want to learn more about Google Sheets hit the subscribe button in the video or on this site (top right!).

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*

 

*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 Shorts: Change the Column and Row Size (0)

Google Sheets: Columns and Rows

If you are new to Google Sheets or spreadsheets in general. This is the post for you.

In this tutorial, we walk through 3 ways to change the size of Columns and Rows. We also throw in some tips on change rows and columns in bulk to increase your workflow, before addressing some pitfalls you might face.

Watch this video on YouTube.

Here is a link to the Sheet containing the character matrix.

Resizing Columns and Rows

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.