Google Sheets How-To Guides

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… Continue Reading How to Convert a Google Sheets File to a PDF

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… Continue Reading How to Save as a CSV from Google Sheets

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… Continue Reading How to Subtract in Google Sheets

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… Continue Reading How to Create a Named Range in Google Sheets

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… Continue Reading How to Make Cells Red if a Number is Less Than Zero in Google Sheets

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… Continue Reading How to Enable Iterative Calculation in Google Sheets

Once you have all of the data in your spreadsheet you might decide that it’s time to format it appropriately. Google Sheets can often do a good job of determining what type of data is in your cells and format it correctly on its own. But if you have values that include currency formatting that… Continue Reading How to Remove Dollar Sign in Google Sheets

Finding data within a large spreadsheet file can be tedious, if not impossible. Fortunately, you have some options when you are trying to figure out how to search in Google spreadsheet files that can make the whole process a lot simpler. How to Search a Spreadsheet in Google Sheets There are a lot of other… Continue Reading How to Search in Google Spreadsheet Files (An Easy 3 Step Guide)

As a Google Apps user, it is really easy to share and collaborate on spreadsheet files with other people that also use Google Sheets. But not everyone is using those applications, and you might need to download Google spreadsheet files into other file types to share them with non-Google users. One of the more common… Continue Reading How to Download a Google Sheet as an Excel File