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:
What Freeze does in a Google Sheets spreadsheet.
How to freeze single or multiple columns and rows by using the menu bar.
How to freeze using right-click on columns and cells.
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.
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.
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.
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.
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,
How to add borders to a range specifying what part of the range the border will be.
Adding colour to your borders.
Adding border thickness or dashes and dotted borders.
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!
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.
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.
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.
