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:
Why you might want to hide columns and rows in Google Sheets.
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.
Google Sheets: WEEKNUM, WEEKDAY, FILTER, VLOOKUP, TODAY
One really helpful metric to check performance is to compare the current weeks worth of data against the previous weeks. I have had need of this in all sorts of projects such as:
Comparing sales performance from previous weeks to current.
Comparing hours worked on different tasks from week to week.
Compare the assessment balance between weekly tests.
Compare attendance numbers.
The problem is you often only receive data in to form of a date, like 1 Nov 2020. We will go through one possible solution to this problem in this tutorial.
We’ll run through an example together that you should be able to quickly adapt to your own project.
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.
