Excel Basics Archives - Page 146 of 176

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

Oct 23, 2022 Excel Basics

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)

Aug 30, 2022 Excel Basics

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)

Feb 2, 2023 Excel Basics

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)

Jun 27, 2022 Excel Basics

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)

Jul 20, 2022 Excel Basics 6

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

Jan 23, 2023 Excel Basics

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

Jan 23, 2023 Excel Basics

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)

Jan 29, 2023 Excel Basics

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

Jan 26, 2023 Excel Basics

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)

May 18, 2022 Excel Basics 2

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

Jan 30, 2023 Excel Basics

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)

Jan 21, 2023 Advanced Excel Exercises

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

Jan 24, 2023 Excel Basics

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)

Jan 25, 2023 Excel Basics

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)

Jan 25, 2023 Excel Basics 4

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