Change the cell colors based on the cell value in Google Sheets - Featured Image

How to change the cell colors based on the cell value in Google Sheets?

There are times when we need to look at mounds of data on our daily spreadsheets. However, without any design elements or visual cues, the scouring the data can be stressful to the eyes. Fortunately, though, we can change the … Read More

Featured Post
Alternated colors list in Google Sheets - Featured Image

How to create an alternated colors list in Google Sheets?

While working with data on Google Sheets, it sometimes gets very difficult to read the data. More so, when there are a huge number of rows and columns to deal with. This is because, by default, the spreadsheet real estate is … Read More

Featured Post
Name ranges in Google Sheets - Featured Image

How do I name ranges or cells in Google Sheets?

Spreadsheets are made up of cells that can hold many types of data. And they usually are referenced using the R1C1 notation, for e.g. B4, or N6. And a group of cells is referenced in this notation R1C1:R2C2, for e.g. … Read More

Featured Post
Google Sheets data formatting guide - Featured Image

Google Sheets data formats guide

Google Sheets spreadsheets application is designed to hold information of many different types. These data types broadly fall into text, numbers, and dates. The data-format settings define how we see the information on a particular cell. By default, the data format … Read More

Featured Post
Different text formats inside cells in Google Sheets - Featured Image

How do I make different text formats inside cells in Google Sheets?

Google Sheets not only allows us to store data, but it offers tools to make it look presentable. Probably many of us are aware of the fact that we can format the entire cell contents. But Google Sheets also lets … Read More

Featured Post
Insert a chart in Google Sheets - Featured Image

How do I insert a chart in Google Sheets?

Spreadsheets are of the most ubiquitous software programs that help a user, beginner or advanced, to quickly get along with numbers. They not only help us store the data but also provide us with necessary tools to derive insights. Charts … Read More

Featured Post
Import RSS feed - Featured Image

Import RSS Feed to Google Sheets

Google Sheets is an advanced spreadsheets application that has made our lives easier because it is ubiquitously accessible. Not only that, it lets us import information from the Internet with functions built right into the application. In this article, we … Read More

Featured Post
Create a form and submit - Featured Image

How do I create a form and forward submissions to Google Sheets?

The Google Sheets has become more versatile because of the capability to tightly integrate with the Google Apps ecosystem. A few years ago, conducting surveys was a daunting challenge. Thanks to the current cloud-based Google suite of applications, everything has … Read More

Featured Post
Links to external destinations - Featured Image

Create links in Google Sheets to external destinations

We know that Google Sheets supports text and numbers in its cells. But, at times we may need to navigate to beyond the spreadsheet application. In this article, we explain how to create links in Google Sheets to external destinations. … Read More

Featured Post
Import HTML tables - Featured Image

Import tables from the web to Google Sheets

We all know how resourceful Google Sheets application has become in our daily life. While it is extremely good with all the basic and advanced spreadsheet needs, it also lets us connect with the outside information with ease. For instance, … Read More

Featured Post