Category: Sheets Posts

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 easily 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

In this post, we’re going to learn how to sort in Google Sheets. We’re going to see how we can sort data in one or more columns, and look at the different options that are available. How to sort data by one column Here we have a list of students’ exam results, which is a… Continue reading How to sort in Google Sheets

In this short post, we’re going to look at how to randomize a list of names. For example, a teacher may want to change the order of a group of students. First, select the cells you want to randomize. Then right-click on the range and then click View more cell actions > Randomise range. Alternatively,… Continue reading How to randomize a list in Google Sheets

In this post, we’re going to look how to merge cells, which combine cells multiple cells into one cell. This allows you to format the cell and can simplify your data and make it easier to read and understand. It’s often used for headers in tables or where you have long text which goes across… Continue reading How to merge cells in Google Sheets

When working with spreadsheets we want to be able to enter data as quick as possible and to make it as easy as possible. Here, we’re going to delve into two practical methods for seamlessly integrating calendars into your spreadsheet cells. By utilising smart chips or data validation, I’ll show you how to speed up… Continue reading How to add a calendar in a cell – Sheets