What replaces Worksheet_Change in Google Sheets?

When to use it

Use onEdit or installable onEdit when Excel macros reacted to typing, paste, or validation changes.

When to skip it

Skip edit triggers when a formula, conditional format, or filter view updates automatically without code.

Related Tutorials

Watch how Worksheet_Change works

Watch more tutorials
Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script

Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script

This is one of the most popular asked first "automations". How to move a...
Create New Worksheet When Google Form Submitted

Create New Worksheet When Google Form Submitted

Automate copying a template for new form submissions with user data inse...
The First Thing I Do When Starting a Google Sheet

The First Thing I Do When Starting a Google Sheet

Are you tired of the default look of your Google Sheets? In this video, ...
Google Sheets Interface Changes

Google Sheets Interface Changes

Showing off New experiences in smart canvas changes to sheets. Including...
Whitening Google Sheet Prank

Whitening Google Sheet Prank

Drive your office crazy by setting a trigger to lighten the text and bac...
Ultimate Checklist in Google Sheets

Ultimate Checklist in Google Sheets

how to create and customize checklists using Google Sheets. I show you h...

Related blog posts

Guides that explain Worksheet_Change in more depth.

Browse the blog

Related terms