Excel how to make drop down options

Method steps.

Start the Excel2010 software and open the electronic ** that needs to add the cell drop-down list.

Select the cell you want to make a drop-down list. Here we want to make a drop-down list for the reimbursement type, there are 5 employees in the table, so we will select the corresponding 5 cells.

Click the Data menu option, and then select Data Validity under Data Validity in the toolbar. "。

In the Data Validity dialog box that appears, select the Sequence option from the Allow drop-down list in the Effectivity Criteria group.

Enter "Accommodation, Transportation, Food" in the text box under "**" and confirm. Note: Accommodation fees, transportation fees, and food expenses should be separated by commas in English.

Back in Electronics, click the drop-down arrow to the right of "Reimbursement Type" in the first employee, and we can see that the drop-down list we just added has been successfully added. This way, you only need to select here when working with data.

How do I create a drop-down menu in Excel?

First, select the area that needs the drop-down menu, click Data Validation under Data, allow to change to sequence, **Enter our content, separated by commas, and click OK to complete.

Excel Tutorial 33: How to make a drop-down menu in Excel Electronics**? These two methods of making are very commonly used.

excel how to make a drop-down menu, I'll teach you!

How do I make a drop-down menu in Excel? It's simple, let me teach you!

How to do a drop-down menu in excel:

First of all, we select a cell, select "Data", then select: "Validity", and then "Validity"."Select Sequence

Then box select the cells you need, OK, and you're done!

You can also try it out and see if it's easy!

How do I create a drop-down menu in Excel?

Click on the data in **, then select the data validity, and set the menu that needs to be dropped down in the data validity, and the setting method is as follows**.

1. Open an Excel** copy and click on the data on the menu bar.

2. Select Data Validity in the menu bar of the data.

3. In the data validity settings window, click the drop-down button of the allow option.

4. Select the sequence inside.

5. Then select the drop-down data in **.

6. Finally, click OK, so that the drop-down menu is successfully made.

Notes:When the data is entered in **, different data needs to be separated by symbols, and the symbols need English symbols.

Here's how:

1. Open the target excel** on the computer, and find the data that needs to set the drop-down options. Here you need to set the drop-down options in the Level column.

2. Then find a blank column, enter the four levels to be filled in (a, b, c d), if necessary, you can hide the four letters.

3. Then select the column of the level that needs to be set to the rough rent width drop-down option, select the "Data" option in the menu, and find "Validity" on its page to click.

4. Then in the bright surface of the boundary rock that appears, select "Sequence" in the validity condition column, and select the area of the four grades entered in the second step in the ** column.

5. Click OK to return. After completing the above settings, you can set the drop-down box options in Excel Electronics**.

Commonly used shortcuts in Microsoft Excel to make **:

1. Press Ctrl+N to create a new excel file.

2. Press Ctrl+W to close the excel file.

3. Press Shift and click the close button to close all open excel files.

4. Insert a worksheet, every time you press the F4 key, a new worksheet will be inserted.

5. Press Ctrl+PageDown or PageUp to quickly view the worksheet. Press Ctrl+9 to hide the rows.

6. Press Ctrl+0 to hide columns.

7. Press CTRL+- (minus sign) to delete the line.

8. Press Ctrl+Left, Right, Left, and Right arrows to quickly jump to the boundary of the current data region.

9. Press Ctrl+Shift+End keys to select non-contiguous areas.

1. Open Excel and select one of the cells.

2. Click "Data" in the toolbar at the top of the page and select the "Validity" button.

3. In the pop-up dialog box, select "Sequence" in "Allow", check "Provide drop-down arrow", and enter the characters you want to display (separated by commas) in **.

4. After clicking OK, a drop-down triangle sign will appear on the right side of the cell.

5. Click on the three-fid high-angle mark on the right to open the drop-down menu, and select the fiber source line according to your needs.

Here are two ways to do it. office2019.

Method 1

Select the range of cells you want to use in the drop-down menu.

Please click Enter a description.

Data Data Validation Data Validation Conditions Vibrato Sequence **, enter "Male, Female" (more can be added) Special Note: Male and female should be separated by English commas. Finalized.

Please click Enter a description.

Once you're set up, go test it out. Click A1, a drop-down menu will appear on the right side, select one with the mouse, and it will be entered automatically.

Please click Enter a description.

Method two.

In F1 and F2, enter : Male and Female.

Please click Enter a description.

Using the drop-down menu, click A1, click the lower button on the right, and select one of the options that appears, and your selection will be automatically entered into the cell. Give it a try.

Please click Enter a description.

Actually, there are many methods online, and these are two typical methods.

Material Tools: Excel2010

1. In column A as shown in the figure below, we enter the information that should be collected in our plan.

2. First of all, we enter a search and replace formula as shown below.

3. Further modify the formula and add a tonne sign after the original value of the formula.

4. After replacing the ton, the formula should be further modified as shown in the figure below.

5. In cell C2, on the basis of the original formula, coat an if function to display the value of column C when the value of column b is empty.

6. After modifying the formula, we determined, and then we can see that the data in column C is just the remaining content after column A minus column B, which achieves the effect of Zen Na we originally set.