Any data you enter into Google sheets is contained within a cell. There will be occasions when you want data from one cell to be stretched across a selection of cells. To do this you need to merge cells in Google Sheets. Not always, but the majority of times merging cells is done to make … Read more
Many people use spreadsheets to record financial transactions. When entering numbers into a spreadsheet, by default, you’ll not see a currency. Instead, the numbers are entered without any association to a specific currency. In this article, you’ll find out how to add a currency to a range of cells. You’ll also find out how to … Read more
When you open a new spreadsheet in Google Sheets you’ll notice the numbers are formatted in a particular way. This is fine if you’re working on a basic spreadsheet and you want some quick results. However, there will be a time when you need to format the numbers to suit your project. This article looks … Read more
One of the most popular and powerful options in Google Sheets is the vlookup function. This powerful yet simple function allows you to do so much when using a spreadsheet. Learning how to do a vlookup may appear difficult at first. However, once you have got used to how it works you will have no … Read more
Conditional formatting is a really useful tool as it allows you to immediately analyse data with visuals. When you have lots of data on a spreadsheet it can easily become a sheet of noise. Conditional formatting in Google Sheets helps you to make certain data highlighted, so you can easily see the data you need … Read more
When using spreadsheets you’ll most likely come across a time when the text in cells is no longer visible. There are a few ways to fix this. This article will look at the different methods and explain how to wrap text in Google Sheets. What happens when text no longer fits in a cell in … Read more
The average function in Google Sheets is an essential function for anyone wanting to find out an average number from a range of cells. Using the Average function in Google Sheets So let’s take a look at how to use the average function in Google Sheets. In the following example, we’ve got a list of … Read more
Let’s take a look at how to divide numbers in Google Sheets. To divide a number in Google Sheets you use ‘/’ in the formula to divide one number from the other. Dividing numbers in Google Sheets In the example below you can see there is the number ‘100’ in cell A1 and we want … Read more