Home  >  Article  >  Topics  >  How to set excel cell selection items

How to set excel cell selection items

藏色散人
藏色散人Original
2020-04-07 10:57:0174497browse

How to set excel cell selection items? Excel table setting options

1. Right-click the mouse, select the "New" option, and then create an Excel table.

Recommended: "Excel Tutorial"

How to set excel cell selection items

2. Enter the corresponding text and numerical information in the Excel table.

How to set excel cell selection items

#3. Select the "Data Validation" option at the top of the Excel table home page.

How to set excel cell selection items

4. In the data validity interface, first select the "Sequence" option in the "Allow" option, and then enter the information you need to select in the "Source" option. "Male" and "Female", and finally click the OK button.

How to set excel cell selection items

#5. Click the cell below the gender option to select the corresponding information from the options.

How to set excel cell selection items

#6. Since then, the operation of setting selection items in the Excel table has been completed.

The above is the detailed content of How to set excel cell selection items. 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