Advanced Excel Archives - Page 50 of 63

How to Add Item to Drop-Down List in Excel (5 Methods)

Apr 20, 2024

Adding items will depend on how a drop-down list is created. We will consider the following dataset for this purpose. Method 1 - Add Item ...

How to Add Item to Drop-Down List in Excel (5 Methods)

How to Make a Data Validation List from Table in Excel (3 Methods)

Jun 20, 2024

Here's a sample data set to use for the validation list. We opened the Data Validation option from the Data tab. We ...

How to Make a Data Validation List from Table in Excel (3 Methods)

Using VBA to Select a Value from a Drop Down List in Excel – 2 Methods

Aug 3, 2024

Creating a Dropdown List from a Generic List in Excel In the dataset below, there are repeated values (Apple in B7 and B9) . Create a ...

Using VBA to Select a Value from a Drop Down List in Excel – 2 Methods

How to Make Dependent Drop Down List with Spaces in Excel

Jun 17, 2024

Let’s say we have 3 Product Lists with two-word names, resulting in spaces among words. We have to generate a drop-down list that allows spaces ...

How to Make Dependent Drop Down List with Spaces in Excel

How to fix a non-working CTRL+F in Excel: 5 Solutions

May 4, 2024

Below is a dataset representing the 5 best-nominated movies in the Best Picture category for the 2022 Oscar Awards. Solution 1 – Set ...

How to fix a non-working CTRL+F in Excel: 5 Solutions

How to Keep Unique Values in a Drop Down List with Excel VBA – 3 Methods

Aug 13, 2024

Quick View: Sub Drop_Down_List_Unique_Values_At_Least_Once() List_Location = "B3" Data = Range(List_Location).Validation.Formula1 Data = ...

How to Keep Unique Values in a Drop Down List with Excel VBA – 3 Methods

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

Jul 9, 2024

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 Copy Filter a Drop-Down List in Excel (5 Methods)

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

Jun 24, 2024

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 ...

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

How to Combine Two Scatter Plots in Excel (Step by Step Analysis)

Nov 11, 2025

In Excel, the combination of scatter plots allows you to show and analyze two separate data sets that are connected to each other. A standard chart ...

How to Combine Two Scatter Plots in Excel (Step by Step Analysis)

How to Remove Duplicates from a Drop Down List in Excel (4 Methods)

Jul 18, 2024

Dataset Overview Let’s assume you have a large Excel worksheet containing information about various fruits and vegetables imported by a country into ...

How to Remove Duplicates from a Drop Down List in Excel (4 Methods)

How to Remove Used Items from Drop Down List in Excel (2 Methods)

Nov 11, 2025

While working with data validation in Excel, you might need to remove used items from the drop-down list to avoid assigning an item in the list ...

How to Remove Used Items from Drop Down List in Excel (2 Methods)

How to Apply Multiple Data Validation in One Cell in Excel: 3 Methods

May 23, 2024

Method 1 - Apply Multiple Data Validation in One Cell in Excel with Specific Criteria STEPS: Combine the criteria formulas in a nested formula ...

How to Apply Multiple Data Validation in One Cell in Excel: 3 Methods

How to Create a Data Validation Drop-Down List with VBA in Excel (7 Methods)

Jun 18, 2024

Method 1 – Embedding VBA to Create a Data Validation Drop-Down List Steps: Press Alt + F11 or go to the tab Developer -> Visual Basic to ...

How to Create a Data Validation Drop-Down List with VBA in Excel (7 Methods)

How to Select from Drop Down and Pull Data from Different Sheet in Excel

Apr 26, 2024

Method 1 - Use the VLOOKUP Function to Select from a Drop-Down and Pull Data from a Different Sheet in Excel We will use a dataset that contains ...

How to Select from Drop Down and Pull Data from Different Sheet in Excel

How to Hide and Unhide Columns Based on a Drop-Down List Selection in Excel

Jul 6, 2024

How to Create a Drop-Down List in Excel STEPS: Select a cell (E3, in this example) on which we’ll create the drop-down list. Go to ...