How to set excel table options

How to set selections in excel table

Recommended: "excel tutorial"

Settings Selection step 1: Open the excel document and select the cells where drop-down options need to be added.

How to set selection items in excel table Figure 1

Set selection items Step 2: Click "Data"->"Data Validity" in the menu ”-> “Data Validity”.

How to set selection items in excel table Figure 2

Set selection items Step 3: In the settings menu on the pop-up page, click "Allow" Select the "Sequence" button.

How to set selection items in excel table Figure 3

Set selection items Step 4: Enter the drop-down options to be set in the cell in the source, use Separate them with English commas "," and click the OK button.

How to set selections in excel table Figure 4

Setting selections Step 5: You can get the effect we want.

How to set selections in excel table Figure 5

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