Andrew Kamphey

Google Sheets wizard at BetterSheets.co

Capitalize All Words or No Words in Google Sheets

Capitalize All Words or No Words in Google Sheets

When working with Google Sheets, you might find yourself needing to adjust the capitalization of text within your cells, whether that means capitalizing each word or making everything lowercase. Here’s a quick guide to help you master these formatting techniques. Capitalizing All Words If you want to capitalize each

Advanced Checkbox Hacks for Streamlined Approvals

Advanced Checkbox Hacks for Streamlined Approvals

Google Sheets is a powerful tool that offers a wide range of functionalities. One such feature that can significantly enhance your workflow is the use of checkboxes for approvals. In this blog post, we will delve into some advanced checkbox hacks in Google Sheets. These tips will help you move

How to Customize PROPER Function in Google Sheets (Creating a Headline Case)

Have you ever wanted to make all the words in your Google Sheet stand out? Here is an easy tutorial for capitalizing each word, just like a title!

Can I get alerted when a tab name is changed?

Can I get alerted when a tab name is changed?

Use Apps Script to receive emails whenever there’s a change in your Google Sheet structure Are you an organization with multiple people working on the same Google Sheets file? Then, you might want to know when one of your people changes something in the spreadsheet, whether that be adding

Google Sheets AI Formula

Google Sheets AI Formula

Does Google Sheets have an AI Formula? No but you can add one. Simple use Apps Script to add an AI formula to your sheets. You can use your own AI from Open AI and this comes out to be much cheaper than even $20 a month for ChatGPT at

Automate Row Deletion in Google Sheets with Apps Script

Automate Row Deletion in Google Sheets with Apps Script

In this post, we'll cover how to remove rows automatically in Google Sheets using Apps Script, ensuring you save time and streamline your spreadsheet management. You're probably already familiar with the manual way of right-clicking and deleting rows, but there's a more efficient way

How to Count Between 1 and 16 in Google Sheets

How to Count Between 1 and 16 in Google Sheets

A question from the Facebook group "I Love Google Sheets" wants to know how to count numbers between 1 and 16 in a series. So let us break it down and look at the best way to do this. The question was "How can I count the

Better Sheets

Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.

Google Sheets Help

Google Sheets Courses

Google Sheet Templates

Google Sheet Tools