How to set up the drop-down menu in Xls reader-How to set up the drop-down menu in Xls reader

Time: 2021-09-18Source: InternetAuthor: monster

Dear friends, you may not know the detailed operation of how to set up the drop-down menu in Xls reader, so today I will explain the steps on how to set up the drop-down menu in Xls reader. If you are interested, come and take a look with me. I hope it can help you.

​ 1. Open the table where a drop-down menu needs to be set and select the cell

How to set up drop-down menu in xls

​ ​ 2. Select data-validity.

How to set up drop-down menu in xls

​​ 3. Create an auxiliary column anywhere else in the table. Enter the contents of the drop-down menu


4. In the pop-up dialog box, select the sequence. The data source selects the location where you just entered the content of the drop-down menu.

How to set up drop-down menu in xls

5.The drop-down menu is now set up.

How to set up drop-down menu in xls

The above is the entire content of how to set up the drop-down menu of the Xls reader brought to you by the editor. I hope it can help you.

Related articles更多>>

Popular recommendations