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.

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.

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!

Did you enjoy the tutorial? Want 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: 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.

Did you enjoy the tutorial? Want 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: 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.

Did you enjoy the tutorial? Want 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: 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!

Did you enjoy the tutorial? Want 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