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.
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.
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.
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 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.
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
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
