Spreadsheet fundamentals

Search Reddit from Google Sheets

Learn how to search Reddit directly from Google Sheets using keyword phrases, perfect for social listening and competitor research. This tutorial also introduces a free template to search across 80 different sites at once.

Expire A Shared Public Link in Google Sheets

Learn how to expire a shared public link in Google Sheets by setting a specific date and time for when access will be revoked, ensuring your spreadsheet remains private after sharing.

How to Change Dropdown Colors and Gray Out Rows in Google Sheets with Apps Script

Learn how to customize dropdown colors and gray out rows in Google Sheets using Apps Script. This tutorial provides step-by-step instructions for enhancing your spreadsheet's functionality.

How To Generate Random Number Once in Google Sheets

Learn how to generate a random number once in Google Sheets using a simple app script, ensuring that the number remains unchanged even after editing the sheet.

Only Get Comment Notifications If You are Mentioned in Google Sheets

Learn how to customize your Google Sheets comment notifications so that you only receive alerts when you are mentioned in comments, streamlining your collaboration experience.

How to Turn Off Comment Notifications in Google Sheets

Learn how to turn off comment notifications in Google Sheets to avoid distractions while collaborating with others. This quick tutorial guides you through the steps to manage your notification settings effectively.

How to Change Edit Access in Google Sheets

Learn how to change edit access in Google Sheets, including how to modify user permissions and share settings effectively.

Search Twitter from Google Sheets

Learn how to search Twitter directly from Google Sheets using a simple formula that encodes your search queries. This video also introduces a powerful template for searching multiple sites at once.

How to Assign Macros To Buttons in Google Sheets

Learn how to assign macros to buttons in Google Sheets to streamline your workflow and enhance your spreadsheet functionality. This tutorial covers creating and linking macros for formatting headers with ease.

How Many Days This Year? Google Sheets Formula

Learn how to calculate the number of days in a year using Google Sheets formulas, including how to identify leap years automatically.

How to Quickly Find Conditional Formatting

Learn how to quickly identify conditional formatting in your Google Sheets, including tips on checking text and fill colors.

Clear Task Row With One Click in Google Sheets

Learn how to clear a task row in Google Sheets with just one click using checkboxes and a simple Apps Script. This video also introduces Sheet Ops, a powerful task management tool with automation features.

How To Add Numbers Automatically in Google Sheets

Learn how to automatically add numbers in Google Sheets using the SUM function and create running totals for your sales data. This tutorial covers essential techniques to keep your data updated effortlessly.

IF Negative Then Zero

Learn how to use the IF function in Google Sheets to convert negative values to zero, ensuring your data remains valid and useful for analysis.

Fix VLOOKUP NA ERROR Quickly

Learn how to quickly fix the VLOOKUP NA error in Google Sheets by using the IFNA function and data validation techniques to enhance user experience.

Is This Conditional Formatting?

Learn how to identify and manage conditional formatting in Google Sheets, including how to check for existing rules and modify them.

How to Stop onEdit Automation in Google Sheets

Learn how to stop onEdit automation in Google Sheets by renaming triggers or commenting out lines of code. This video provides practical tips for managing your Google Sheets scripts effectively.

5 Google Sheet Templates You’ll Get as a Better Sheets Member

Discover five powerful Google Sheet templates available exclusively to Better Sheets lifetime members, designed to enhance productivity and streamline workflows.

How to Add Shortcut to Tab in Google Folder

Learn how to create shortcuts to specific tabs in Google Sheets using Google Drive and AppScript. This video covers two effective workarounds to link directly to tabs within your spreadsheets.

How to Protect Spreadsheet From Yourself

Learn how to protect your Google Sheets from accidental edits, including how to set permissions and use App Script to maintain important formulas.

Automate Based on Google Form Response

Learn how to automate actions based on Google Form responses using Google Apps Script, including sending customized emails based on the city selected in the form.

Password Protect Google Sheets

Learn how to password protect your Google Sheets to restrict access to sensitive data using Google Forms and Apps Script in this informative tutorial.

How to Ungroup Rows in Google Sheets

Learn how to easily ungroup rows in Google Sheets with this quick tutorial. Discover the steps to manage your row groups effectively and enhance your spreadsheet organization.

How to Group Cells in Google Sheets

Learn how to efficiently group cells and rows in Google Sheets to organize your data better. This tutorial covers the steps to group rows and the keyboard shortcuts to make the process quicker.