How to make excel dropdown menu super simple tutorial[Win11 Solutions]
34 2021-08-24 12:20
Since excel was upgraded to versions after excel2013, such as excel2016 and 2019, the method of recover data damaged seagate hard drive using the drop-down menu is different, so if the new version is installed, how to make the drop-down recover data dead external hard drive menu of the table.In fact, it's still very simple. Here are some pictures and texts to teach you how recover data dead laptop hard drive to operate.
1. In the following figure, let's take gender as an example. In the gender column, we recover data erased hard drive mac need to select male and female in the form of a drop-down menu. At this time, we only need to select recover data external hard drive clicking the table under the first gender, as shown in the figure below
2. Click on the data in the toolbar, recover data external hard drive free then click on data verification, and click on the data verification in the pop-up small box, as recover data external hard drive linux shown in the figure below.
3. Then click Settings in the pop-up data verification box
4. Then recover data external hard drive partition select allowable as a sequence in the verification condition, as shown in the figure below
5. Then recover data external hard drive raw enter "male, female" in the source box and separate them with English commas, as shown in the figure recover data external hard drive ubuntu below, and then click OK
6. At this time, in the first table under our gender, you can use the recover data failed external hard drive drop-down menu to select men and women, but there is no such function in the performance tables corresponding recover data failed hard drive mac to other rows. We only need to use the mouse to click the first one that already has Just pull recover data failed sata hard drive down on the lower right corner of the table with the drop-down function, and pull it all the way to recover data faulty usb memory stick the row with no corresponding name.
7. After the drop-down is complete, all people in the gender recover data files from hard drive column can use the drop-down menu to select male and female
8. As shown in the figure below, we can recover data fm external hard drvie choose male and female at will, and the drop-down menu function is completed.
9. In addition, if recover data for broken usb drive you don't want to manually fill in the content of the drop-down menu, we can call the form content recover data formatted hard drive freeware to do it. Let's take the nationality as an example to teach you how to do it.
10. Fill in the recover data formatted hard drive mac different nationalities in the other forms first, and then select the data and data verification in the recover data frm dead hard drive first form under the nationality column, as shown in the figure below
11. Then select the allowed recover data from 3.5 hard drive sequence in the same way, and click the small arrow grid icon behind the source position, as shown recover data from a dead harddrive in the figure below
12. Then you will be asked to select the content source. We select the different recover data from accidental esd usb nationalities that have been filled in before and box them all, as shown in the figure below. After recover data from bad hard drive selecting, the source location will be displayed as the table number starting with $, and finally recover data from bad hard drives click OK.
13. Then our form has the function of the following menu, and the selectable content is recover data from beeping hard drive different nationalities, as shown in the figure below.
14. Like the previous gender, we pull down recover data from broken hard drive the bottom right corner of the first table with menu function, and pull it to the column of other recover data from broken hard drives people, which has the same ethnic selection menu function.
Summary: The excel drop-down menu is so recover data from broken micro usb easy to implement, is it different from the old excel before, so it is still worth seeing for novices, recover data from broken usb key I hope everyone can easily use the drop-down menu function.