Spreadsheet fundamentals

How to Create URL to Call a Number in Facetime

Learn how to create a URL to call a number in FaceTime directly from Google Sheets using a simple hyperlink formula. This tutorial covers various formats for phone numbers and how to troubleshoot common errors.

How to Fix WhatsApp Number Errors in Google Sheets

Learn how to quickly fix WhatsApp number errors in Google Sheets by removing unwanted characters and formatting your numbers correctly for seamless integration.

How to WhatsApp From Google Sheets

Learn how to create WhatsApp links directly from Google Sheets, ensuring your phone numbers are formatted correctly to avoid errors. This tutorial covers the necessary steps to hyperlink WhatsApp numbers efficiently.

How to Change Time Zone in Google Sheets

Learn how to change the time zone in Google Sheets to ensure your formulas and Apps Script projects reflect the correct time settings. This tutorial covers the steps to adjust your time zone settings effectively.

How to Change the Timezone of Your Apps Script

Learn how to change the timezone of your Apps Script to ensure it aligns with user settings, avoiding potential issues with timestamps across different sheets and users.

How To Duplicate a Template For Every Day of the Year

Learn how to efficiently duplicate a template in Google Sheets for every day of the year using Apps Script, ensuring your spreadsheet remains manageable and fast.

How To Create a Tab For Every Day of the Year

Learn how to create a Google Sheets tab for every day of the year using Apps Script. This tutorial walks you through the process of automating tab creation with a simple script.

How to Continue a Sequence in Google Sheets

Learn how to continue sequences in Google Sheets, whether with numbers, dates, or text, using simple mouse tricks. This video covers various types of sequences and their limitations.

How to Delete Protected Range in Google Sheets

Learn how to easily delete a protected range in Google Sheets with this step-by-step guide. Discover where to find the trash icon and how to confirm the deletion of your protected ranges.

How to Edit Protected Range in Google Sheets

Learn how to edit and manage protected ranges in Google Sheets, including how to change permissions and delete protected ranges effectively.

How to Lock Range in Google Sheets

Learn how to lock a range in Google Sheets to prevent unwanted edits, ensuring your important data remains unchanged while allowing modifications around it.

How to Lock Cell in Google Sheets

Learn how to lock specific cells in Google Sheets to prevent unwanted edits, ensuring your data remains intact as you update your spreadsheet over time.

How to Join Text without Extra Spaces

Learn how to effectively use the TextJoin function in Google Sheets to combine text without introducing extra spaces, even when dealing with empty cells.

Hey! Look At This!

Learn how to effectively draw attention to specific cells in Google Sheets using colors, comments, and shapes like arrows. This video provides tips on making important information stand out in your spreadsheets.

How To Subtract $10 from every Row Quickly for Data Cleaning

Learn how to quickly subtract $10 from every row in Google Sheets while handling text and numbers effectively, ensuring smooth data cleaning without errors.

How To Duplicate a Tab and Move it to the End of your Google Sheets

In this video, learn how to duplicate a tab in Google Sheets and automatically move it to the end of your spreadsheet using Apps Script. The tutorial covers creating a custom menu and scripting the duplication process with date formatting.

How To Make a Table in Google Sheets

Learn how to create a table from scratch in Google Sheets, including how to add data validation and dropdown menus for enhanced functionality.

How To Add Many Columns in Google Sheets

Learn how to quickly add multiple columns in Google Sheets with this easy tutorial. Discover efficient methods to insert many columns at once, enhancing your spreadsheet management skills.

How To Add a Column in Google Sheets

Learn how to efficiently add a column to the far right or left in Google Sheets with this quick tutorial. Master the techniques to enhance your spreadsheet management skills.

How to Stop an Apps Script in Google Sheets

Learn how to stop a running Apps Script in Google Sheets with this quick tutorial. Discover the steps to terminate a script that may be looping or causing issues.

Get Rid of that Red Line

Learn how to eliminate the red line error in Google Sheets when using custom functions created in Apps Script. This video guides you through the simple steps to ensure your function is recognized as a native formula.

How to Merge Cells Vertically

Learn how to merge cells vertically in Google Sheets to enhance the aesthetics of your spreadsheets. This video covers the steps to merge cells and provides examples of how it can improve your data presentation.

How to Merge Cells Horizontally

In this video, learn how to merge cells horizontally in Google Sheets to create cleaner headers or enhance the aesthetics of your spreadsheets. Discover various methods to simplify your data presentation effectively.

How to Unlink a Google Form From a Google Sheet

Learn how to unlink a Google Form from a Google Sheet, allowing you to delete the Form Responses tab without losing existing data. This video guides you through the steps to manage your forms and sheets effectively.