Home  >  Article  >  Topics  >  How to set drop-down options in excel

How to set drop-down options in excel

藏色散人
藏色散人Original
2020-05-19 09:22:4110876browse

How to set drop-down options in excel

How to set excel drop-down options

Goal

We create a new personnel annual leave statistics table , add the company's department to the department column for selection. The company's department can be said to be a value that will not change for a long time, so it can be processed using a drop-down menu.

Recommended: "Excel Tutorial"

How to set drop-down options in excel

We save the company's department details in a column for later use. Use later. Note here that a cell stores a name.

How to set drop-down options in excel

Select one of the cells in the department column of the table. Generally, select the first cell for formatting. After selecting the cell, click Data in the menu bar, find the data validity and click to expand.

How to set drop-down options in excel

In the pop-up data validity, click the Allow drop-down menu and click to select the sequence.

How to set drop-down options in excel

Click the source icon, select the department information column we added earlier, and click OK after the selection is completed.

How to set drop-down options in excel

How to set drop-down options in excel

Place the mouse on the lower right corner of the set cell and drag it down so that the entire column of cells can be selected for drop-down selection.

How to set drop-down options in excel

#Hide our basic data columns to make the table neat and beautiful, and the entire operation is completed.

How to set drop-down options in excel

The above is the detailed content of How to set drop-down options in excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn