Excel Basics

Excel Dependent Drop Down List (Create with Easy Steps)

In this article, we will demonstrate how to create a dependent drop down list in Excel. To explain the process, we'll use the following data set with ...

12 Ways to AutoFill Numbers in Excel

Method 1: AutoFill a Column with a Series of Numbers Example Model: Use the Fill Handle option to autofill the series of numbers starting from 1. ...

How to Insert Date in Excel (7 Suitable Methods)

Inserting dates in Excel can be used for a variety of purposes, including data tracking and date-time calculations. In this article, we are going to ...

How to Autofill Dates in Excel – 3 Methods

The dataset showcases Names of Candidates for an interview. To AutoFill their interview dates: Method 1 - Dragging the AutoFill ...

How to Do Automatic Numbering in Excel (12 Methods)

Dataset Overview For automatic numbering, we will be working with a dataset of countrywide sales lists for different products. Method 1 - ...

AutoFill Cell Based on Another Cell in Excel (5 Easy Methods)

Method 1 - Autofill to End-of-Data We have a set of names in the Name column. We need to assign an ID serially. Steps: Select cell C5. ...

Excel Formula Based on Drop-Down List (6 Suitable Examples)

Here's an overview of how you can use a drop-down list to affect other cells or create additional drop-down lists. Read on to learn how to make ...

How to Link a Cell Value with a Drop Down List in Excel (5 Ways)

Method 1 - Make a Dynamic Drop-Down List to Link a Cell Value We have a list of Item Names of some computer accessories. We will make a dynamic ...

Conditional Drop Down List in Excel (Create, Sort and Use)

Method 1 - Create a Conditional Drop-Down List with a Classified Data Table In Cell C13, we’ll create an independent drop-down list for the brand ...

How to Use IF Statement to Create Drop-Down List in Excel

Method 1 - Insert IF Statement with Direct Cell Reference to Create Drop-Down List In our example, we will select a sports category as Favorite ...

How to Remove a Drop Down List in Excel – 4 Methods

This is an overview: The sample dataset showcases Product, Price, and Payment Method. Payment Method contains a drop-down list. ...

How to Create a Drop Down List from Another Sheet in Excel

This tutorial will demonstrate how to create a drop-down list from another sheet in Excel, and also from multiple sheets. Example 1 - ...

How to Edit Drop Down List in Excel (3 Basic Approaches)

In Excel, a drop down list is a helpful feature to swiftly fill in the right data in a field (cell or column). Once you build the drop-down list you ...

How to Make a Drop Down List in Excel (Independent and Dependent)

Example 1 - Create an Independent Drop-Down List in Excel We have a list of popular Samsung smartphones. We’ll make a drop-down list in Cell E7 from ...

Excel Auto Sort When Data Changes (9 Examples)

In this article, we'll demonstrate how to use the SORT function or combine it with other functions to sort data automatically when data is changed ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo