Category: Sheets Posts

Once you’ve added your data onto a sheet, you’ll probably want to format it in some way. In this post, we’ll look at formatting data in Sheets. By default, numbers entered are considered just that, normal numbers, but sometimes you want specific types of numbers, e.g. percentages, currency, dates, times, scientific, numbers to certain decimal points.… Continue reading Google Sheets – Formatting your data

The fundamental building blocks of any spreadsheet are the cells. So clearly, it’s important to understand how to use them well. In this post, I will focus on the various ways you can format cells, so that the cells display the information you want, visually look professional and most importantly, will help you understand your… Continue reading Google Sheets – Cell formatting

When working with tables in a spreadsheet, we often want them to be easy to read and understand. To help us, Sheets has a quick little tool, which allows us to add alternating colours to the rows of our data, making them not just prettier but much easier to read, whilst being really quick to… Continue reading How to add alternating row colours to Google Sheets

In this post, we’re going to look at two key ways you can add extra information to your sheet, without affecting the format of your sheet: Notes and Comments. Sometimes people confuse these, as they both give extra information in the cells, but there is a clear difference between the two. The key difference is:… Continue reading Google Sheets – What’s the difference between notes & comments?

Sometimes we spend time colouring in our sheets so that the data is more visible, in a way that it can be read and understood really quickly and that the most important points can be ascertained with ease. Wouldn’t it be great if Sheets could colour your data automatically, depending on a set of conditions? Well,… Continue reading Google Sheets – Conditional Formatting & custom formulas

Let’s look at how you can filter your data to show a particular aspect of it. There are two ways to do this: Filter (by value & by condition) Filter View Filter – By value If we have a set of data, we can add some filters to enable us find the information we want. In… Continue reading Google Sheets – Filtering your data

In this post, let’s look at how we can move, copy and paste our data on the sheet, starting with the basics and then introducing some lesser-known methods that will save you time and effort. Moving cells (drag & drop, cut & paste) Copying and pasting cells Paste special (values, format, all except borders, formulas, transpose)… Continue reading Google Sheets – Moving, copying & pasting data

Following on from my post Controlling rows & columns, let’s look at some further ways you can control your rows and columns: Selecting multiple rows/columns Deleting unwanted rows & columns Hiding rows and columns Freezing rows and columns Selecting multiple rows or columns There are two ways to select more than one row or column.… Continue reading Google Sheets – Controlling rows & columns (Part 2)