Sometimes just one Google Sheets tab is not enough. Maybe you want to tidy up your data, create unique insights in a separate tab or generate a spectacular graphic dashboard or all your daw data, knowing how to create a Google Sheets tab is going to be a vital part of your success as a Google Sheets creator.
In this tutorial we’ll cover:
The different ways you can add a new blank sheet tab.
Duplicating a current sheet tab.
Renaming your sheet tab.
Accessing a large number of sheet tabs.
Hiding and unhiding your sheet tab.
Remember!
Don’t forget to let your team know that you are using tabs. They always forget 🤣.
If you want to learn some more Google Sheets basics skills check out the link to the playlist below:
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.
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:
What is conditional formatting and how to use it.
Basics of conditional formatting.
Example 1: Conditional Formatting Grade Ranges 0:23
Example 2: Conditional Formatting empty cells or cell only containing values. 4:36
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:
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.
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.
Here is a link to the Sheet containing the character matrix.
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.
