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 […]

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 […]

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 […]

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 […]

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 […]

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. […]

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 […]

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 […]

Have you recently come across a Google Sheets spreadsheet that you cannot edit because it is in view only mode? If this is the case with you, then read on […]

A fairly annoying error in Google Sheets is the circular dependency detected error. When Google Sheets returns this error, it provides no information on why this error is happening. In […]