Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

Excel Basics

Use VLOOKUP with Multiple Criteria in Excel (6 Methods + Alternatives)

If you have worked with Microsoft Excel for a while, you know how functional the VLOOKUP function is. We can search for an element from a large ...

How to Use VLOOKUP Function in Excel VBA (4 Examples)

In this article, I’ll show you how you can use the VLOOKUP function of Excel in VBA. You’ll learn to use the VLOOKUP function with a user-defined ...

How to Remove Checkbox in Excel (6 Easy Methods)

Sometimes while using Excel we have to use a checkbox to keep track of the progress of our To-do list or the opinions of the customers etc. After the ...

How to Name a Cell in Excel (4 Easy Ways)

We can name multiple items in Excel. Name a cell is one of them. There are items to name such as, ⧭ A Cell or A Range of Cells ⧭ Certain Values ...

Macro to Insert Row and Copy Formula in Excel (2 Methods)

In this article, I’ll show you how you can develop a Macro to insert a row and copy a formula using VBA in Excel. You’ll learn to insert one or more ...

How to Clear Contents in Excel Without Deleting Formulas

Oftentimes, we may want to remove values from our Excel spreadsheet. Now, what if we need to erase only the contents without affecting the formulas? ...

How to Apply Conditional Formatting to Each Row Individually

Conditional Formatting is a versatile feature embedded in Excel, that comes up with a lot of flexibility in terms of highlighting cells. You can ...

How to Return Value if Cell is Blank (12 Ways)

If you are looking for some of the easiest ways to return value if a cell is blank, then you will find this article useful. So, let’s get started ...

Change Font Color Based on Value of Another Cell in Excel

Changing the font color of a dataset is one of the essential tasks of Microsoft Excel. We do it to have a clear and attractive look at our dataset. ...

How to Add Leading Apostrophe In Excel (5 Ways)

You can convert a number into text by adding a leading apostrophe. From this Article you’ll get to know how you can add leading apostrophe in Excel. ...

How to Perform Data Validation for Alphanumeric Only in Excel

Alphanumeric characters are a mix of alphabetical and numerical characters. There are 36 (A-Z and 0-9; case insensitive) or 62 (A-Z, a-z and 0-9; ...

How to Combine Cells in Excel (4 Methods + Shortcut)

While dealing with Microsoft Excel, we often have to combine values in cells in different situations. MS Excel has numerous ways to join cells, and ...

How to Concatenate Range with Separator Using VBA in Excel

In this article, we’ll show you how you can concatenate a range of cells with a given separator using VBA in Excel. You’ll learn to concatenate the ...

How to Hide Zero Values in Excel Pivot Table (3 Easy Methods)

Pivot table is one of the essential tools of Microsoft Excel. If you have worked with that, you might know that. It gives us a detailed view and ...

How to Highlight Row If Cell Is Not Blank (3 Methods)

The Conditional Formatting feature in Excel gives you different options to highlight cells of your dataset based on different conditions. You can ...

ExcelDemy
Logo