How to Find and Replace Multiple Values in Excel with VBA (3 Examples)

Below is a dataset that contains information about the departments of employees. We will try to use VBA to find and replace the department's values. ...

[Fixed] Excel Formula Bar Not Showing Cell Contents

This article illustrates how to fix if the excel formula bar is not showing cell contents. Formula bar in excel allows us to enter or copy formulas. ...

How to Find a Character in String from Right in Excel (4 Methods)

The sample dataset contains information for a group of people who work in an office and have their own ID and User ID. Method 1 - Using ...

How to Find the * Character (Not used as a Wildcard) in Excel – 2 Methods

This is an overview: Press CTRL+F and enter asterisk (*) in the search box. If you click Find Next, no results will be displayed. ...

Excel VBA: Count Rows with Specific Data (8 Examples)

We use Excel VBA code to perform work by simply clicking a single button only. In this article, we will discuss how to count rows with specific data ...

How to Find and Replace Text in Word Document Using Excel VBA (5 Methods)

Method 1 - Using Excel VBA to Find and Replace a Text String in a Word Document Open the Word document that contains the list of products. ...

How to Copy Filter a Drop-Down List in Excel (5 Methods)

Method 1 - Using an Advanced Filter Option to Copy a Filter Drop-Down List  We have the products listed in the Product column, but the products are ...

How to Find and Replace from List with Macro in Excel (5 Examples)

Example 1 - Find and Replace a Word from a List with Excel Macro In the following dataset, we want to find the product Cable and replace it with TV. ...

How to Use Formula for Past Due Date in Excel (3 Methods)

To demonstrate how to use formulas for due dates, we'll use a dataset containing data titled Project Name and Deadline. How to Use a ...

How to Find the Last Row with a Specific Value in Excel (6 Methods)

Here, we have a sample dataset containing Customer Name, Gender, Loan Purpose, Job, and Credit Risk. The dataset is repetitive. Snoop, Almanda, and ...

How to Return YES If 2 Cells Match in Excel (10 Methods)

Below is a dataset that contains the names of the school's tennis and rugby players. Some of them play both games. Method 1 - Use the ...

Compare Two Cells Using Conditional Formatting in Excel (3 Methods)

We have a dataset of 3 columns titled Yearly Revenue Statement. The first column contains different unit names. The second and third column contain ...

How to Hide a Formula but Allow Input in Excel – 2 Methods

This is an overview: Consider the following bank interest calculator: You want to allow users to input data in C4:C7, but you don’t ...

Select All Cells with Data in a Column in Excel (5 Methods+Shortcuts)

In this article we'll discuss 5 methods to select all cells containing data in a column, and 3 related keyboard shortcuts. We'll use the following ...

How to Filter Date Range in Excel (5 Easy Methods)

We'll consider the sample dataset that contains the sales quantity of some electronic products in a shop in January, February, and March. We'll ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo