Visit our collection of articles and tutorials that can help you improve your Google Sheets spreadsheets and fix problems you may be experiencing.
Not sure where to start? Check out our featured Google Sheets guides below:
Google Sheets has a lot of options that can make it easier for you to enter and organize data. Some of these options don’t involve any formulas or data tolls, however, and will affect the display of the rows and columns in your spreadsheet. One option that is particularly noteworthy involves “floating” a row so … Read more
If you’ve worked on a big spreadsheet in Google Sheets and you needed to reference data in the first column, then you might have been frustrated with all of the scrolling. Not only is this annoying and a waste of time, but it can also lead to mistakes. Fortunately, you can freeze an entire column … Read more
I use header rows in almost every spreadsheet that I create in Google Sheets. Not only does it help me to make sure that I am putting the right data in the right column, but it also helps the people that are going to be reading that data later. Our tutorial below will show you … Read more
Some formatting options will have a minimal amount of effect on the appearance of data. For example, changing the font size or using a different font may not make the text any more or less readable. But if you draw a line through some of your text, it’s possible that some people might have trouble … Read more
One of the best features of working with Google apps like Google Sheets is how well they work when you are doing an online collaboration. But occasionally you will need to create a file that you can share with other people, such as those who aren’t able to work in the Google Sheets app on … Read more
The CSV file format is very versatile, and it provides a means to view and edit data in a lot of different applications. If you have been working on a spreadsheet in Google Sheets and you need to provide that data ot someone in the .csv file type, then you may be curious about how … Read more
Spreadsheet applications like Microsoft Excel and Google Sheets are more than just a way to organize and display data. They are also powerful applications capable of performing a lot of calculations. Some of these calculations can involve basic functions like multiplication, division, addition, and subtraction. Our tutorial below will show you a handful of ways … Read more
I have been working with spreadsheets in Microsoft Excel and Google Sheets for a long time, and have grown accustomed to doing things a certain way. This is particularly true when making formulas, as it’s very easy to make a mistake with the structure of the formula, so I tend to always do things the … Read more
When you are poring over a large amount of data in a spreadsheet it can be easy to miss the important values. One way that you can make sure you see things, such as numbers that are less than zero, is by making them look different. A common way to achieve this is by making … Read more
Many people that use Google Sheets won’t encounter problems with the settings that it has in the default configuration. But if your spreadsheet contains a formula with a circular reference that you want to calculate multiple times, then that can be an issue. Our tutorial below will show you how to find the iterative calculation … Read more