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
Category: Posts
How to sort 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
How to randomize a list 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
How to merge cells 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
How to filter duplicate rows in Google Sheets
In this post, we’re going to look at how we can identify duplicate rows and also extract both unique rows and duplicate ones using a single formula. We’re going to look at different ways to do this and how we can use one formula which will extract a list of duplicate rows and and also… Continue reading How to filter duplicate rows in Google Sheets
Google Forms – How to add titles and sections
In this post, we’re going to look at how to add titles and sections. Plus, how you can move sections and preview your form. If you’ve got a longer form, you’ll probably want to add sections and possible pages to your form. There is an important difference between titles and sections. Titles – These add… Continue reading Google Forms – How to add titles and sections
How to remove duplicates in Google Sheets
In this post, we’re going to look at how to remove duplicates from a list in Google Sheets. This will remove complete rows if they are found to contain a duplicate value. List with duplicated data Here, I have a list of imaginary subscribers and I want to remove any where the email address is… Continue reading How to remove duplicates in Google Sheets
How to move a folder to a Shared Drive
In this post, we’re going to look at moving folders from My Drive to a Shared Drive both for a Google Workspace account and a personal Gmail account How to move a folder to a Shared Drive with a Workspace account Here, I have a folder on My Drive in my Workspace account. I want… Continue reading How to move a folder to a Shared Drive
How to create video presentations in Slides
It’s now possible to create videos of a presentation in Slides which you can then easily share with a link with others. How to record a video presentation Open your Slides document and you will see in the top right-hand corner the recording (Rec) icon. Click on that to record a new video. Click “Record… Continue reading How to create video presentations in Slides
How to add a calendar in a cell – 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