Grouping and ungrouping columns Sometimes we have large spreadsheets where we want to work with only certain rows or columns. Sheets gives the option to group rows or columns, allowing you with one click to show and hide numerous rows and columns, rather than having to go into the menus and hide the ones you… Continue reading Google Sheets – Grouping rows and columns
Category: Sheets Posts
Google Sheets – Controlling Rows & Columns (Part 1)
In this post, let’s look at various ways you can modify the rows and columns on your sheet. Part 1 (this post) Changing the row size of rows and columns (to fit data / manually / enter size) Selecting a whole row or column Inserting and deleting a row or column Inserting and deleting specific cells… Continue reading Google Sheets – Controlling Rows & Columns (Part 1)
Google Sheets – Formatting your data
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
Google Sheets – Cell formatting
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
Questionnaires – Automatically send feedback to individuals
It’s common to use questionnaires at the end of a course to get feedback on the course and teacher. When you have a lot of teachers, it can be hard work analysing that feedback and splitting into the different teachers. Here we’re going to look at how we can automatically send the individual feedback to… Continue reading Questionnaires – Automatically send feedback to individuals
Create a Book inventory with Google Sheets & Apps Script
Here we’re going to make a simple book inventory, where we’ll be able to control the location of the books and also find out where a book is. This uses a mixture of GAS code and Sheets functions. We’ve got 3 sheets: Front page – This is what the user will see and use. In… Continue reading Create a Book inventory with Google Sheets & Apps Script
Google Sheets – INDEX and MATCH (VLOOKUP alt.)
In this post, we’re going to look at how to use INDEX and MATCH to look up data and see how it can be more powerful than the commonly used VLOOKUP. In a previous post, we looked at how we can quickly look up tables for certain information, using the VLOOKUP function. This function is… Continue reading Google Sheets – INDEX and MATCH (VLOOKUP alt.)
Sheets Functions – WEEKDAY, WORKDAY, NETWORKDAYS, EDATE, EOMONTH
Following on from my post on the basic date functions, let’s look at some really useful functions that work with dates, namely: WEEKDAY, WORKDAY, NETWORKDAYS, EDATE and EOMONTH, plus we’ll see an example with the CHOOSE function. With these we’ll: Find out the day of the week of a particular date Work out a deadline date Work… Continue reading Sheets Functions – WEEKDAY, WORKDAY, NETWORKDAYS, EDATE, EOMONTH
How to add alternating row colours to Google Sheets
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
Google Sheets – What’s the difference between notes & comments?
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?