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

Advanced Excel

Create Excel Filter Using Drop-Down List Based on Cell Value

A drop-down list filter is basically a list of unique names. If you select any of the items from the drop-down list, you will get the corresponding ...

Autocomplete Data Validation Drop Down List in Excel (2 Methods)

Data validation is an interesting feature of Excel. This feature offers control to the user to input values in a cell. Users can not input whatever ...

Excel Data Validation Drop Down List with Filter (2 Examples)

In this article, I will discuss how you can filter excel data using a Data Validation drop-down list. Usually, in Microsoft Excel, we use the Filter ...

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

Drop-down list is an interesting feature of Microsoft Excel. Using this tool, we can choose items from a given list, without typing any value. It ...

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

When new elements are inserted into the bottom of an Excel table, it extends dynamically. Tables are one of the most effective features in an Excel ...

VBA to Select Value from Drop Down List in Excel (2 Methods)

Dropdown lists are a very useful feature to perform various Excel related tasks. Implementing VBA is the most effective, quickest, and safest method ...

How to Make Dependent Drop Down List with Spaces in Excel

Creating a dependent drop down list is common practice among Excel users. However, generating a dependent drop down list with spaces in Excel ...

[Solved!] CTRL+F Not Working in Excel (5 Fixes)

To find values, we frequently use the Find and Replace tool by using the shortcut CTRL+F. But you might face some unexpected problems while using the ...

How to Convert Text to Formula Using the INDIRECT Function in Excel

This article illustrates how to convert formula in text format to a real formula to make calculations by using the INDIRECT function in Excel. The ...

[Fixed]: Can’t Find Project or Library Error in Excel (3 Solutions)

While working with a large Microsoft Excel dataset, sometimes we see that our VBA macros show an error named “can’t find project or library”. It ...

Unique Values in a Drop Down List with VBA in Excel (A Complete Guide)

In this article, I’ll show you how you can remove the duplicate values from a drop down list of a worksheet in Excel with the help of VBA and keep ...

Create Data Validation Drop-Down List with Multiple Selection in Excel

In this article, we will learn how to create an excel data validation drop-down list with multiple selection. While we use data validation it only ...

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

If you are trying to copy the filter drop-down list in Excel effectively, then this article is for you. Here, we will discuss different 5 ways for ...

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

This article will provide some valuable methods on how to filter a range of date(s) in Excel. Suppose you have sales information for one month, but ...

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

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

ExcelDemy
Logo