How to Make a Lightbox in a Google Sheet
Two ways to make pop-up images in a Google Sheet
Aug 20, 20246 min read118
Command Palette
Search for a command to run...
#google-sheets
Articles tagged with #google-sheets
Google Sheets Tutorial – How to Enable Multiple Selection Data Validation Using Apps Script
Originally published for freeCodeCamp In this article I will show you how to allow for multiple items to be selected using the drop-down data validation feature in Google Sheets. Here's the Google Sheet we'll use for the example. You can make a copy...
Feb 6, 20238 min read53
Excel Tutorial – How to Clean Data with the TRIM() and CLEAN() Functions
Originally published for freeCodeCamp Without clean data, your spreadsheet is knocking on death's door. In this tutorial, I will show you two fast ways to clean up the data in your Excel or Google Sheets spreadsheet. When dealing with data sets, esp...
Jan 27, 20236 min read55
How to Calculate Percentage Differences Between Two Numbers in Excel - Cell Percentage Change Tutorial
Originally published for freeCodeCamp Spreadsheets are powerful and awesome. 💪 In this tutorial I will show you four ways to find the percentage difference between two numbers in Excel. I'll also show you how to use custom functions in Google Sheet...
Dec 20, 20227 min read30
Google Sheets Tutorial – How to Use Regex and VLOOKUP to Display Images from Google Drive
Originally published on freeCodeCamp. Images make many things better. And Google Sheets is one of those things. The easiest way to add an image to Google Sheets is to simply insert one into your sheet. But if you have added many images this way, you...
Aug 15, 20226 min read33
How to Query Data in Google Sheets
Use the built in SQL-like Query Language
Jun 17, 20224 min read48