An interesting workaround allows you to calculate age in Google Sheets using a date of birth. The formula allows users to subtract the current day from the date of birth […]
Google Sheets
How to Sort by Date in Google Sheets
Just like alphabets and numbers, dates can also be sorted from earliest to latest and vice-versa. In Google Sheets this can be done with the built-in sort function, which allows […]
How to Generate Random Numbers in Google Sheets
Looking to populate your Google Sheets spreadsheet with a bunch of randomized data? You can vastly speed up the process by making use of built-in functions. There are two different […]
How to Sort by Multiple Columns in Google Sheets
To easily analyze large spreadsheets, you can make use of sorting functions that will organize your data. For those using Google’s productivity suite, the built-in sorting function allows users to […]
How to Sort Alphabetically in Google Sheets
Once a spreadsheet contains numerous lines of data, it becomes difficult to find what you are looking for. It then becomes important to properly sort the data to ensure it […]
How to Insert Bullet Points in Google Sheets
While Google Docs makes it easy to add bullets with a menu option, there is no such option to insert bullet points in Google Sheets. Instead, you will need to […]
How to Color Alternate Rows in Google Sheets
A lot of people choose to color alternate rows of a spreadsheet to make it more readable. Previously color alternating rows in Google Sheets was a lengthy process, however Google […]
How to Fix #REF! Error in Google Sheets
The #REF! error is one of the most annoying formula parse errors in Google Sheets. The error is usually caused by a missing/invalid reference or circular dependency in your formula. […]
How to Fix #DIV/0! Error in Google Sheets
A common error in Google Sheets is #DIV/0!. In this article we will be taking a look at what this error is, what causes the error and how you can […]
How to Freeze Rows and Columns in Google Sheets
When working with large datasets it becomes difficult to keep track of what each row and column represents as you start scrolling down or rightwards. Luckily you can easily solve […]