Basics

Google Sheets Copy Conditional Formatting but Change Reference Cell

Conditional formatting is a very dynamic feature in Google Sheets. It enables us to format our dataset with the criteria we put. Sometimes we need to ...

[Fixed!] Wildcard Is Not Working in Google Sheets (5 Solutions)

In Google Sheets, we use wildcards to find data and perform different operations using functions. But sometimes problems arise that the wildcard is ...

[Solved!] Paste Values Is Not Working in Google Sheets (2 Fixes)

We often Copy and Paste values from one cell to another in Google Sheets. One might even copy values from other files like Google Docs, MS Excel, MS ...

How to Copy and Paste Data Validation in Google Sheets (3 Ways)

We often use data validation in Google Sheets to limit the kinds of data one can enter. One of the most common uses of data validation is to make a ...

How to Send Email Based on Date in Google Sheets (2 Methods)

A most interesting feature of Google sheets is that we can send email based on date. Sometimes we need to send emails to a certain number of people ...

Google Sheets Use Filter to Remove Duplicates in Column

In Google Sheets, the easiest way to remove duplicates from a vast range of data is using the Filter menu. With the help of the filter menu just ...

How to Use IF Condition Between Two Numbers in Google Sheets

If we're talking about developing a financial model for business forecasting, Google Sheets excels without a doubt. When undertaking financial ...

How to Find and Replace Multiple Values in Google Sheets

Sometimes we input wrong or improper data subconsciously, knowingly or by any kind, and eventually it comes up to correct them all. Obviously, we ...

How to Receive Notifications of Changes in Google Sheets

The most fantastic feature of Google Sheets is that it is easily shareable among users. When we work with a long dataset and with different users, ...

How to Use Paste Special in Google Sheets (8 Examples)

Copying data from another source and pasting it into Google sheets is a common task that all users perform. You may sometimes need to copy and paste ...

How to Copy and Paste a Table from Google Sheets (6 Examples)

We frequently use tables in Google Sheets to represent our data. Sometimes, we need to copy those tables to another sheet in the same or different ...

How to Paste Values Only in Google Sheets (4 Quick Ways)

Sometimes we need just the output rather than the input. Google sheets and Excel are the most used software for any company, industry, or any sector ...

Create Drop Down List in Google Sheets from Another Sheet

Google Sheets drop-down list is very useful when you want to enter data from some predefined options. The drop-down list is one of the efficient ways ...

How to Edit Drop-Down List in Google Sheets

In Google Sheets, a drop-down list is an interactive feature that speeds up data entry and standardizes it. We may wish to edit the drop-down list in ...

How to Set Up Custom Notifications in Google Sheets (2 Ways)

In an office where several people work on the same spreadsheet, it could be challenging to keep track of which modifications were made, when they ...

OfficeWheel
Logo