Basics Archives - Page 12 of 25

How to Add Color to Drop Down List in Google Sheets (Easy Steps)

August 10, 2023 Basics

This article highlights how to add color to the drop down list in Google Sheets. Using a drop down list is very useful to choose a specific option ...

How to Add Color to Drop Down List in Google Sheets (Easy Steps)

How to Create Dependent Drop Down List in Google Sheets

August 10, 2023 Basics

A dependent drop down list is used when one wants to show only relevant information for subsequent dropdowns. It is also known as a dynamic dropdown ...

How to Create Dependent Drop Down List in Google Sheets

Google Sheets: Sum if Cell is Not Blank

October 31, 2022 Basics

In this tutorial, we will look at how to sum if a cell is not blank in Google Sheets over a range of cells. The Basic Way to Sum if a Cell is Not ...

How to Sum Cells from Different Sheets in Google Sheets (3 Easy Ways)

October 30, 2022 Basics

In this simple tutorial, we will look at a few ways we can use to sum cells across different sheets in Google Sheets. While the idea is simple, ...

How to Sum Cells from Different Sheets in Google Sheets (3 Easy Ways)

Google Sheets: Sum If there are Multiple Conditions (3 Ways)

October 27, 2022 Basics

In this simple tutorial, we will look at a few scenarios where we sum values in Google Sheets if there are multiple conditions. The Core of the ...

Google Sheets: Sum If there are Multiple Conditions (3 Ways)

Find the Sum of Cells with Specific Text in Google Sheets

October 26, 2022 Basics

In this simple tutorial, we will look at a few ways to find the sum of cells with specific text in Google Sheets. While it sounds simple, there ...

Google Sheets: Sum an Entire Column (4 Easy Ways)

October 24, 2022 Basics

Adding or summing values in a spreadsheet is a common process. And with such a versatile application like Google Sheets, we have so many ways we can ...

Google Sheets: Sum an Entire Column (4 Easy Ways)

Format Cell as Text in Google Sheets (3 Simple Scenarios)

October 23, 2022 Basics

In this article, we will look at a few scenarios to format a cell as text in Google Sheets. There are many reasons why we’d want to do that, of ...

Format Cell as Text in Google Sheets (3 Simple Scenarios)

How to Automatically Add Numbers in Google Sheets

October 20, 2022 Basics

The word add can mean a couple of things when incorporated into a task in a spreadsheet. In this case, it can mean either automatically to add a ...

How to Automatically Add Numbers in Google Sheets

Google Sheets: Sum of Cells with Text (4 Examples)

October 19, 2022 Basics

In this simple tutorial, we will look at a few example scenarios where we sum cells with text or those that depend on text in Google Sheets. Note ...

Google Sheets: Sum of Cells with Text (4 Examples)

Google Sheets: If Cell Color is Red Then Take Action

October 18, 2022 Basics

In this article, we will look at a few ways to work with the condition "if cell color is red the take action" in Google Sheets. With conditional ...

Google Sheets: If Cell Color is Red Then Take Action

How to Sum Colored Cells in Google Sheets (2 Ways)

October 15, 2022 Basics

A common question in the spreadsheet space is: How do you sum colored cells in Google Sheets? This question arises since it is a common ...

How to Sum Colored Cells in Google Sheets (2 Ways)

How to Count Cells in Google Sheets (4 Easy Ways)

October 13, 2022 Basics

Being one of the most fundamental processes, there are multiple scenarios where you’d count cells in Google Sheets: Count Empty Cells Count ...

How to Count Cells in Google Sheets (4 Easy Ways)

Count Cells with Color in Google Sheets (3 Easy Ways)

October 12, 2022 Basics

To make it clear, there are no direct ways to count cells with color in Google Sheets. At least, no built-in features are available that is. So, ...

Count Cells with Color in Google Sheets (3 Easy Ways)

How to Append Text in Google Sheets (An Easy Guide)

March 21, 2023 Basics

In this article, we will look at a few scenarios of how to append text and other values in Google Sheets. While most of the methods call for the ...