Google Sheets Beginners – Hide and unhide columns and rows(13)

Google Sheets

Sometimes it is helpful to hide and unhide columns in Google Sheets. You may have some completed tasks that you want to indicate as completed to your users or you may want to hide columns that you have used for working. Whatever, the case hiding rows in columns is a helpful trick to have in your Google Sheets toolbox.

In this video tutorial we  will cover:

  1. Why you might want to hide columns and rows in Google Sheets.
  2. Hiding and unhiding individual columns and rows.
  3. Hiding and unhiding ranges of columns and rows.
  4. Hiding and unhiding selected columns or rows.

Check it out now!

If you want to grab more Google Sheets basics, you click in the link below to the playlist:

Google Sheets Beginners playlist

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

 

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

 

Did you enjoy the tutorial? Want to upskill and get 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: 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:

 

Did you enjoy the tutorial? Want to upskill and get 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: Conditional Formatting (09)

Google Sheets: Conditional Formatting

Conditional formatting is a powerful tool that helps you to highlight cells that meet a certain value. You can format cells, that contains:

  • date ranges
  • Number ranges or specific numbers
  • Exact text or partial text

Once you have identified your condition you can change the cell’s background colour, font-weight or font colour.

You can access conditional formatting in Google Sheets by going to Format > Conditional formatting. Make sure you select the range you want to format first, though.

In this video tutorial we will cover the basics of Conditional Formatting in Google Sheet:

  1. What is conditional formatting and how to use it.
  2. Basics of conditional formatting.
  3. Example 1: Conditional Formatting Grade Ranges 0:23
  4. Example 2: Conditional Formatting empty cells or cell only containing values. 4:36
  5. Example 3: Conditional Formatting text that contains certain words or letters. 6:06

If you are keen to follow along here is a link to the Google Sheet I was working in:

Unformatted template to follow along with the video.

Simply, go to File > Make a copy to have your own copy of the file.

If you want to create custom conditions that are not in the list you really should check out this tutorial:

Google Sheets: Conditional Formatting with Custom Formula

If you want to check out more on my Google Sheets Beginners course you can check the playlist out here:

Google Sheets: Beginners

Did you enjoy the tutorial? Want to upskill and get 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