Advanced Excel

How to Create a Form with Drop Down List in Excel

Method 1 - Create Form Area Select an area on your Worksheet where you will create your custom form. Select your background color. We chose ...

Creating a Drop-Down Filter to Extract Data Based on a Selection in Excel – 4 Methods

This is the sample dataset: Method 1 - Create a Drop-Down Filter to Extract Data Based on Selection with Helper Columns in Excel Insert 3 ...

How to Remove Blanks from a Data Validation List in Excel (5 Methods)

Method 1 – Using the OFFSET Function Steps: Enter the following formula in cell C5: =FILTER(B5:B14,B5:B14<>"") Here, the ...

How to Create a Drop-Down List with Unique Values in Excel – 4 Methods

The sample dataset showcases Product name, Category, and Country to which the product is exported. Method 1 - Insert a Pivot Table to ...

Problem and Solution of Data Validation Not Working Copy Paste in Excel

Method 1 - Reason for Data Validation Not Working Copy Paste in Excel Steps:  We selected Column B which contains the Employee Name. From ...

Create a Searchable Drop Down List in Excel (2 Methods)

The following picture highlights what you can do with a searchable drop-down. Imagine you have the following dataset in the worksheet ...

How to Use a Custom VLOOKUP Formula in Excel Data Validation – 2 Methods

The sample dataset showcases sales in different regions. Method 1 - Using a Drop-down List of Data Validation with the VLOOKUP Function in ...

How to Use Named Range for Data Validation List with VBA in Excel

If you are looking for the easiest ways to use named range for data validation list in Excel VBA, then you will find this article useful. Named ...

How to Stop Excel from Auto Formatting Dates in CSV: 3 Methods

Method 1 - Save the CSV File as Text Document to Stop Excel from Auto Formatting Dates STEPS: Open the CSV file. Click on the File tab. A ...

How to Use Excel VBA to Create Data a Validation List from Array

  The salespersons' dataset has their working region and selling products. We will create a data validation list for the Region and Product ...

How to Use a Data Validation List from Another Sheet (6 Methods)

The below dataset has two columns: The Product purchased by a customer will be inserted using the Data Validation drop-down list from another sheet. ...

How to Use Data Validation in Excel with Color (4 Ways)

We have a dataset containing five columns: Serial Number, Candidate Name, Acquired Number, DoB, and Candidate’s Code. We will use different Columns ...

How to use Excel VBA with an Advanced Filter – 6 Examples

This is the sample dataset. Example 1 - Use Excel VBA to Filter Data in the Current Location Set the criteria in B16:E17. Step 1: ...

How to Use IF Statement in Data Validation Formula in Excel (6 Ways)

Here, we have some records of some of the products and their corresponding salesperson’s names of a company. By using this dataset, we will ...

Apply Custom Data Validation for Multiple Criteria in Excel (4 Examples)

In this article we'll discuss how to use Custom Data Validation with multiple criteria to prevent incorrect or out-of-range data being entered into a ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo