How to Make a Lightbox in a Google Sheet
Two ways to make pop-up images in a Google Sheet
Aug 20, 20246 min read119
Command Palette
Search for a command to run...
#spreadsheets
Articles tagged with #spreadsheets
6 Ways to number in Excel
Since last we spoke I’ve been recording several new long and short form videos. Check out the YouTube Channel if you haven’t. I’ve also wrapped up training for a marathon I’ll be racing on March 3rd… 🤞🤞 Now to the sheets… Do you ever feel lost in E...
Feb 29, 20243 min read138
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 read57
Accounting Number Format in Excel – How to Apply it to Selected Cells
Originally published for freeCodeCamp In this article I will show you how to format cells in Microsoft Excel. We'll be looking particularly at the Accounting format for cells with numbers. At the end of the article I'll give you two bonuses: a short...
Jan 18, 20234 min read126
How to Clear Formatting in Excel – Remove Format From a Cell
Originally published for freeCodeCamp In this article I will show you how to clear formatting from a cell in Excel. If you want the quick and dirty version, it's first up and will require you to simply click a couple times. If you want to become a s...
Jan 12, 20235 min read36
I Made 📃Goals and 💲Money This Year | 👉Dev Retro 2022
(The goals were a lot more impactful)
Dec 28, 202211 min read83