Google Sheets keeps a detailed version history of your workbook. You can use this version history to track changes and identify when, where and who made a change. You can make a copy of an old version or revert your current sheet back to an old version.
Find out how to check your workbooks changes history in Google Sheets.
In this tutorial, I’ll cover,
Why you might need to check the version history. 00:05
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 provides an email notification tool that allows you to get email notifications for changes to a Google Sheet or when a Google Form that is connected to your Google Sheet receives a submission. You can set your email notifications to be received when each change occurs or as a daily summary.
There are some really good use-cases where you might need to receive notifications of changes to a Google Sheet. Here are two common examples that I have used notifications for in the past:
Tech Support: I have had a form connected to a sheet and then had my team use notifications to get an email when a user submits a tech support issue. We set it up so that the first responder adds their initial to a column related to the lastest form submission so that everyone knows that it is being addressed.
Project Management: I’ve run a Gantt chart for project management and when someone from a project I have assigned has completed a portion of a task and is ready for review, they check a box. At the end of each day, I get an email notification summarising the changes in the chart.
Check out the details below on how to get notifications on a Google Sheet and how to read the email notification summary.
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.
Have you ever had your editors edit something on your Google Sheet that they weren’t meant to? Find out how to protect cells, ranges and sheet tabs in Google Sheets.
The main tutorial
In this tutorial, I’ll cover,
Why you may need to protect certain parts of your Google Sheet 00:02
Protecting a range of cells. 00:50
Selecting editors to your protected range. 01:22
How protected ranges look for the user. 01:46
Protecting entire columns. 02:35
Editor hierarchy. 03:18
What to protect? 04:13
The ‘protect’ sidebar. 05:17
Protecting an entire sheet tab. 05:57
Viewing a list of what has been protected in your Google Sheet. 07:17
Hot tip for hiding sheet tabs from other users. 07:42
If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:
How to prevent editors from moving columns and rows
You can prevent editors from moving columns and rows by selecting a range of rows, for example, A1:E1and preventing the user from editing those cells. Now when the editor tries to move any of those columns, they will not be able to.
check out the video tutorial below for more on this:
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 anything like me, you may find yourself regularly tidying up imported datasets or data from users that contain duplicates that could potentially corrupt your data analysis.
Fortunately, Google Sheets has a quick tool to help you to remove duplicates with a simple click of the button.
In this tutorial, I’ll cover,
Why you might need to remove duplicates. 00:10
How to remove duplicates for a single row 00:30
How to remove duplicates that contain a header row. 01:20
Removing duplicates from multiple selected rows 02:02
What data ‘Remove Duplicates’ will and won’t match. 04:48
If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:
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 Beginners: Protecting cells, ranges and sheet tabs (23) [updated Feb 2022]](https://i0.wp.com/yagisanatode.com/wp-content/uploads/2020/11/23-Google-Sheets-Shorts-Protect-Cells-Ranges-Sheet-Tabs.jpg?fit=1200%2C675&ssl=1)
