Excel Basics

Excel Cell Color: Add, Edit, Use & Remove

Sometimes we need to color our Excel cell to make the dataset unique, highlighted, beautiful, and easy to visualize. In this article, we will know ...

Excel If Cell Contains Text Then Return Value (8 Easy Ways)

Excel has various built-in functions to match and fetch value if a cell contains text or string. In many cases, we try to search for a text or string ...

How to Find Lowest 3 Values in Excel (5 Easy Methods)

Often, we come across a situation where we need to find the lowest values in a dataset. In this article, we’ll use SMALL, ROW, and AGGREGATE ...

How to Set a Minimum and Maximum Value in Excel (6 Easy Methods)

In a dataset sometimes we need to input entries between ranges. In that case, entries between one minimum and one maximum value represent a whole ...

How to Remove Blank Cells in Excel (10 Easy Ways)

Blank cells inside the dataset sometimes become disturbing. These also create difficulties in the calculation. There are numerous methods to remove ...

How to Remove Non-Printable Characters in Excel (4 Easy Ways)

Every Character printable or non-printable bears a Unicode Character Code or Value. The First 32 characters (0-31) of Unicode or ASCII in programs to ...

How to Count Odd and Even Numbers in Excel (3 Easy Ways)

Sometimes in a dataset, we have to count odd and even numbers in Excel to understand the entries. In this article, we’ll describe ways to count odd ...

How to Use Excel Sheet Name From Cell Value (Three Ways)

In many cases, you may need to use an Excel sheet name from a particular cell value such as creating an excel sheet name from a cell value, referring ...

COUNTIFS with Multiple Criteria (5 Easy Methods)

COUNTIF counts cells in a range depending on a single criterion. Whereas COUNTIFS count cells in one or multiple ranges depending on multiple ...

Example of Mixed Cell Reference in Excel (3 Types)

Cell reference is an important thing in Excel. It is easier to call cell using references than using values. There are three types of cell references ...

How to Name a Range in Excel (5 Easy Tricks)

In Microsoft Excel, there are several methods to name a range and make it also dynamic simultaneously. The named ranges are easy to prepare. They are ...

Delete Row If Cell is Blank in Excel (4 Methods)

While working with a large number of data, you can find numerous blank cells in your dataset. As a result, it can misinterpret your dataset or can ...

How to Delete Every nth Row in Excel (Easiest 6 Ways)

If you are looking for the easiest ways to delete every nth row in Excel, then you may find this article helpful. Sometimes it is needed to delete ...

How to Select Every Other Row in Excel(6 Ways)

Select is one of the most needed tasks of Excel. While performing functions or formulas in multiple rows we may require to select every other row. In ...

How to Compare Three Columns in Excel Using VLOOKUP

VLOOKUP is a lookup and reference function to find and fetch data from a range in Excel. VLOOKUP finds and compares values by rows for a single ...