Spreadsheet fundamentals

Make Your Spreadsheets Easier to Read

Discover simple tips to enhance the readability of your spreadsheets, making them easier on the eyes and more visually appealing. Learn how to adjust colors, fonts, and styles for a better spreadsheet experience.

How to Share a Spreadsheet Without Sharing a Spreadsheet

Learn how to share a Google Sheet without granting access to the actual spreadsheet, using methods like screenshots, file downloads, and PDF exports.

Launching SheetOps

Discover how SheetOps transforms your business operations into a streamlined command center using Google Sheets, enhancing accountability and visibility for task management.

Proof of Life in Google Sheets

In this video, learn how to create a 'Proof of Life' spreadsheet in Google Sheets that sends a confirmation email monthly and deletes itself if not confirmed within 30 days. The tutorial covers using Google Apps Script to manage the process and set up triggers.

Add a Button To Automate Add a Row with Category

Learn how to automate adding a new row with a category selection in Google Sheets using a custom button and Google Apps Script. This tutorial simplifies the process, allowing you to add rows with just one click.

How to Lock a Tab In Place in Google Sheets

Learn how to lock a tab in place in Google Sheets using Google Apps Script, ensuring your important sheets remain in a specific order even when changes are made.

How to Insert Date In a Cell in Google Sheets

Learn how to easily insert and manage dates in Google Sheets, including using the TODAY function and creating a date picker for seamless date entry.

How to Automatically Copy Tab Every Week

Learn how to automate the process of copying a checklist tab in Google Sheets every week using Apps Script and triggers, ensuring you start each week with a fresh template ready for use.

Expense Tracker Template with Data Entry Form Inside Sheets

Learn how to create a simple expense tracker template in Google Sheets with a data entry form for easy expense management. This tutorial covers setting up a dashboard, automating data entry, and summarizing expenses over specific date ranges.

Create an Automated Extended Weekly Calendar View in Google Sheets

Learn how to create an automated extended weekly calendar view in Google Sheets that updates dynamically to show multiple weeks ahead. This tutorial builds on previous methods to enhance your calendar functionality effortlessly.

Make a Tour of the Sheet

Learn how to create an interactive tour of your Google Sheets tabs using App Script, making it easier for users to navigate and understand your spreadsheet's layout and functionality.

Create a Household Chores Board in Google Sheets

Learn how to create a household chores board in Google Sheets that visually organizes tasks by person, similar to a Kanban board. This tutorial shows you how to filter chores and create checklists for easy management.

How To Color Code Drop Down List for Whole Row in Google Sheets

Learn how to color code drop down lists in Google Sheets to enhance your data visualization. This tutorial covers step-by-step instructions for applying color coding to entire rows based on drop down selections.

How To Calculate Average Workout Time Per Weekday

Learn how to calculate the average workout time per weekday using Google Sheets, including tips on using the AVERAGEIF function and managing your data effectively.

How to Create a Sequential ID when Google Form Submitted to Google Sheets

Learn how to create a sequential ID for Google Form submissions in Google Sheets using Google Apps Script. This tutorial covers both methods: using a dedicated sheet and utilizing document properties.

Conditional Formatting With Checkboxes in Google Sheets

Learn how to use checkboxes for conditional formatting in Google Sheets to visually manage your tasks. This tutorial covers setting up checkboxes, applying custom formatting, and enhancing your checklist functionality.

Number Rows If Blank Rows in Google Sheets

Learn how to effectively number rows in Google Sheets, even when there are blank rows, using simple formulas and tricks.

How to Set 1 Hour Expiration to Share Google Sheets

Learn how to set a one-hour expiration for sharing Google Sheets, ensuring that your data is only accessible for a limited time. This quick tutorial walks you through the steps to manage access effectively.

How To Grey Out Unused Cells

Learn how to effectively gray out unused or blank cells in Google Sheets using conditional formatting techniques. This video provides step-by-step instructions to enhance your spreadsheet's visual clarity.

Spreadsheet's Birthday

Discover how to create a fun automation in Google Sheets that celebrates your spreadsheet's birthday with a toast! This video guides you through building a function using Apps Script to determine when your spreadsheet was created and notify you on its birthday.

Show More Decimal Places Each Day in Google Sheets

Learn how to automate the process of increasing decimal places in Google Sheets daily with this fun tutorial from Sheet Fools. Discover how to use Google Apps Script to create a trigger that enhances your spreadsheet's appearance without altering the underlying data.

Text Tilts 1 degree every day

In this video, learn how to create a fun automation in Google Sheets that tilts your header text by one degree every day, adding a playful twist to your spreadsheets. Follow along as we set up the script and triggers to automate this quirky feature.

How to Delete Every Blank Row

Learn how to efficiently delete every blank row in Google Sheets using Google Apps Script. This tutorial guides you through the process step-by-step, ensuring you can automate row deletion effectively.

How Many Days Until 4th of July

Learn how to create an automatic countdown to the 4th of July using Google Sheets formulas. This tutorial demonstrates how to handle date differences and errors effectively.