Spreadsheet fundamentals

How to Move a Cell in Google Sheets

Learn how to easily move cells in Google Sheets using drag-and-drop or keyboard shortcuts. This video provides practical tips to enhance your Google Sheets experience.

Automatic Weekly Calendar View

Learn how to create an automatic weekly calendar view in Google Sheets that updates with your events, making it easy to visualize your schedule for the week ahead.

Create Reminders Daily to Check Sheet EMAIL CALENDAR TASK

Learn how to set up daily reminders to check your Google Sheets through email, Google Calendar, and Google Tasks using Google Apps Script. This tutorial walks you through creating automated notifications to ensure you never miss an important update.

How To Insert Image Inside a Cell in Google Sheets

Learn how to insert images directly into cells in Google Sheets, including methods for uploading images and using URLs. This video provides step-by-step instructions to enhance your spreadsheet with visual elements.

How To Insert Image Over Cells in Google Sheets

Learn how to insert an image over cells in Google Sheets, allowing for creative designs like banners or drawings while maintaining data visibility. This tutorial also covers how to assign scripts to images for automation.

How To Set Print Page Breaks In Google Sheets

Learn how to set print page breaks in Google Sheets to effectively manage your print layout and ensure your data is organized across multiple pages.

How To Print Selected Cells In Google Sheets

Learn how to print selected cells in Google Sheets and export them as a PDF with this quick tutorial. Get tips on customizing your print settings for a more tailored output.

How To Print Google Sheets On One Page

Learn how to print your entire Google Sheets workbook on one page, including all tabs, by exporting it as a PDF with customized headers.

How To Change Margins In Google Sheets

Learn how to adjust margins in Google Sheets for printing, including options for normal, narrow, and wide margins, as well as custom settings for your specific needs.

How to Delete Bottom Rows of a Google Sheet, SO ANNOYING

Learn a quick and efficient method to delete unwanted bottom rows in Google Sheets, making your spreadsheets cleaner and easier to navigate.

Daily Countdown Email from Google Sheets

Learn how to set up a daily countdown email reminder using Google Sheets and Apps Script, ensuring you never miss an important date again.

Add Formula When Form Submitted

Learn how to automatically add formulas to your Google Sheets when a form is submitted using Google Apps Script. This tutorial covers creating a function and setting up triggers to streamline your data processing.

How To Change Cell Size In Google Sheets

Learn how to easily change the cell size in Google Sheets by adjusting row and column dimensions to create the perfect layout for your data.

How To Separate First And Last Name In Google Sheets

Learn how to easily separate first and last names in Google Sheets using the SPLIT function and other methods. This video provides quick tips and tricks to streamline your data management.

How To Underline In Google Sheets

Learn how to underline text in Google Sheets using simple keyboard shortcuts and creative border techniques to enhance your spreadsheet's appearance.

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.