Posts

Following on from the my post on rows and columns, let’s look at some more ways to control rows and columns in Google Sheets for a more organized sheet layout. Selecting Multiple Rows or Columns There are two easy ways to select multiple rows or columns. If the rows or columns are next to each… Continue reading Manage Sheets rows & columns like a pro

In this post, I’ll walk you through essential techniques to customize rows and columns, from resizing and selecting entire rows and columns to splitting text into columns. Let’s dive into these to help you better structure your Google Sheets for ease of use and readability. Check out my video which goes through how to use… Continue reading Mastering Rows and Columns in Google Sheets

Formatting data in Google Sheets When working with data in Google Sheets, formatting cells is key to making your spreadsheet clear and visually appealing. Whether you’re dealing with currency (e.g., $500 for rent), percentages (e.g., 15% for a discount), dates (e.g., 9/9/2024 for a deadline), or plain numbers (e.g., 123 for product quantities), applying the… Continue reading How to format data in Google Sheets

Cell formatting in Google Sheets is a simple but powerful way to make your data more readable and visually appealing. By customizing how your information looks, you can make patterns and insights stand out. Let’s dive into some key formatting techniques! For a detailed, step-by-step guide on how to apply these formatting techniques, check out… Continue reading Enhance your Google Sheets: Cell Formatting

Google Sheets is an incredibly powerful tool, capable of much more than just data entry. You can perform complex calculations, send emails, draw pictures, and even play games! However, before jumping into advanced functions, it’s important to start with the basics. Check out this video which covers all the basics: Creating a Google Sheet To… Continue reading Google Sheets – The Basics

Do you ever find yourself staring at a spreadsheet full of information, wishing there was an easier way to organize it? Well, fret no more! Google Sheets has a powerful tool called the Group By View that can help you quickly categorize and analyze your data in seconds. This post will walk you through the… Continue reading How to quickly group data in Sheets

Stop the Status Update Emails! Automate Notifications with Google Sheets. Tired of your team emailing you every time they complete a task? There’s a better way! Google Sheets can now send you automatic email notifications when data is changed, saving you and your team time. Learn how to set up this handy feature in this… Continue reading How to send automatic notifications from Sheets

In this post we’re going to see how to wrap text in Google Sheets, how to clip text, and how to just let it overflow, with the help of Nibbles the hamster and some revealing questions for our friends. Text overflow Normally, if you write too much in a cell you will see that it… Continue reading How to wrap text in Google Sheets

In this post, we’re going to look at how we can search in Google Sheets for specific text, numbers, formulae, and links. Search in Google Sheets Here we have a list of customers and we want to find any called “pott”. Press Ctrl + F and the search box will appear. Type in the search… Continue reading How to search in Google Sheets