Uploaded March 2025 | Updated September 2026, 1 week ago
It's time to pull a few pranks in Google Sheets! In this video, I show you 6 different hilarious ways to pull a prank in Google Sheets, with virtually limitless possibilities and customization for your own purposes. I purposefully chose ways that are easy to implement, so you can have a prank up in running in less than 10 seconds using the easiest method, and less than 5 minutes for the most elaborate.
Make sure to drop your own ideas or share how you implemented one of these in your own workplace!
And just a reminder, prank responsibly! Remember, there is version history on Google Sheets, so you can restore previous data if needed, but if your prank involves important or sensitive data, it may not go over well.
0:00 Intro
0:32 1. Conditional Formatting
1:58 2. Custom Number Formats
3:02 3. Obnoxious Data Validation
4:12 - Apps Script Methods
4:35 4. onOpen Script
6:56 5. onSelectionChange Script
8:36 6. onEdit Scripts (multiple methods)
It's time to pull a few pranks in Google Sheets! In this video, I show you 6 different hilarious ways to pull a prank in Google Sheets, with virtually limitless possibilities and customization for your own purposes. I purposefully chose ways that are easy to implement, so you can have a prank up in running in less than 10 seconds using the easiest method, and less than 5 minutes for the most elaborate.
Make sure to drop your own ideas or share how you implemented one of these in your own workplace!
And just a reminder, prank responsibly! Remember, there is version history on Google Sheets, so you can restore previous data if needed, but if your prank involves important or sensitive data, it may not go over well.
0:00 Intro
0:32 1. Conditional Formatting
1:58 2. Custom Number Formats
3:02 3. Obnoxious Data Validation
4:12 - Apps Script Methods
4:35 4. onOpen Script
6:56 5. onSelectionChange Script
8:36 6. onEdit Scripts (multiple methods)
