Better Sheets on YouTube

How to Fill Right Text

Learn how to efficiently fill cells to the right in Google Sheets using the command R shortcut. This video tutorial provides tips and tricks to enhance your spreadsheet skills.

How To Fill Down Formulas

Learn how to efficiently fill down formulas in Google Sheets using quick methods like double-clicking and the Command D shortcut. This video provides practical tips to save time when working with large datasets.

How To Fill Range with Top Left Text

Learn how to efficiently fill an entire range in Google Sheets using the command enter method, saving time and clicks compared to traditional methods.

How To Reference Another Spreadsheet in Google Sheets

Learn how to reference another spreadsheet in Google Sheets by using the IMPORT RANGE function to pull data from different workbooks into your dashboard.

How to Reference Another Sheet in Google Sheets

Learn how to reference another sheet in Google Sheets effectively, including how to handle spaces in sheet names and create a dashboard that summarizes data from multiple sheets.

Highlight Text In a Cell in Google Sheets

Learn how to highlight specific text within a cell in Google Sheets using text color and formatting options. This quick tutorial covers essential tips for making your data stand out.

Select a Word, Get a Number in Google Sheets with a VLOOKUP Table

Learn how to use a dropdown menu and VLOOKUP function in Google Sheets to select an exercise and automatically retrieve the corresponding calories burned per hour. This tutorial simplifies the process into three easy steps for efficient tracking of your daily activities.

Log Every Time a Google Sheet is Opened

Learn how to log every time a Google Sheet is opened using Google Apps Script. This tutorial covers creating a logging function that captures timestamps and user information.

Better CONCATENATE for Combining Strings

Discover a better way to combine strings in Google Sheets using the ampersand method instead of the traditional CONCATENATE function. This video explores the limitations of CONCATENATE and introduces simpler alternatives for effective text manipulation.

How to Check for Conditional Formatting in Google Sheets

Learn how to easily check for conditional formatting in Google Sheets by examining text and fill colors, and discover how to manage your conditional formatting rules effectively.

How to Change Checkbox Value in Google Sheets

Learn how to customize checkbox values in Google Sheets from true/false to any text you prefer, such as 'approved' or 'not yet approved'. This video guides you through the steps to set up custom values for checkboxes effectively.

Add Table to Google Sites

Learn how to effectively add a table from Google Sheets to your Google Site by embedding it with an iframe, ensuring accessibility while maintaining data protection.

Sort Column in Google Sheet AUTOMATICALLY!

Learn how to automatically sort columns in Google Sheets using various methods, including manual sorting, formulas, and Google Apps Script triggers.

Quickly Add Text In Front of Text with Apps Script

Learn how to automatically add text in front of existing text in Google Sheets using Apps Script, including creating a custom menu for easy access.

How to Automatically Number Rows in Google Sheets

Learn how to automatically number rows in Google Sheets using the ROW and SEQUENCE functions, making data management easier and more efficient.

Create Google Form Automatically

Learn how to automate the creation of Google Forms directly from Google Sheets with just a few clicks. This video guides you through building a custom menu using Google Apps Script, making it easy to share templates with others.

How To Randomize a Sequence in Google Sheets

Learn how to randomize a sequence in Google Sheets using the sequence function and the randomized range feature. This tutorial provides step-by-step instructions for creating a random number sequence efficiently.

Find Your Spreadsheet ID in Google Sheets

Learn how to find the unique ID of your Google Sheets document and its individual tabs, which is essential for various functionalities and integrations.

How to Share Without Letting Others Edit your Google Sheets

Learn how to share your Google Sheets without allowing others to edit by using viewer or commenter permissions, and discover how to create a view-only copy of your sheet using the import range function.

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.