:Tutorial for beginners on tables: How to make a multi-level drop-down list-Table skills免费ppt模版下载-道格办公

Tutorial for beginners on tables: How to make a multi-level drop-down list

Picture and text skills

Multi-level drop-down menus can not only save input efficiency, but also ensure data standardization. So how to implement a multi-level drop-down menu?

分界线.png

1. When there is little data, you can directly use the drop-down list to enter manually.

▪Select the area where you want to add a multi-level list, and then click "Data""Drop-down list" under the > tab.

录制_2021_10_11_14_53_28_719.gif

▪In the "Drop-down List" dialog box, click on the new manual input option in the upper right corner.

录制_2021_10_11_14_53_55_473.gif

Secondary and secondary drop-down menus refer to the ability to display a corresponding list of options based on the content of the previous cell.

▪First of all you need to prepare a correspondence table between cities and jurisdictions, so that you can read the corresponding jurisdictions based on the city.

录制_2021_10_11_14_56_36_45.gif

▪Then select all the corresponding areas, press the key combination "Ctrl+G" to bring up the positioning dialog box, and select Constant to confirm.

录制_2021_10_11_14_57_06_497.gif

▪Then click the "Specify" button under the "Formula" tab and select the first position. At this time, the batch definition of names is completed.

录制_2021_10_11_14_57_31_925.gif

▪After defining the name, select the city column, click "Data" - "Validity", select "Sequence" in the validity condition column, select the city name row in "Source" and confirm.

录制_2021_10_11_14_58_11_519.gif

▪Select the jurisdiction column, enter the "Data Validity" dialog box, then select "Sequence", then enter the formula =INDIRECT (B2) in the source and confirm.

录制_2021_10_11_14_59_14_718.gif

▪ For three-level drop-down menus, please note that the title in the data source needs to be composed of a first-level drop-down menu and a second-level drop-down menu, such as Jinwan District, Zhuhai City.

录制_2021_10_11_15_00_29_641.gif

▪Then repeat the previous steps, first locate, then define the name through the "Specify" button, and finally in the "Data Validity" dialog box, select the sequence and enter the source =INDIRECT (B2&C2). .

录制_2021_10_11_15_01_01_584.gif

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/biao-ge-xin-shou-jiao-cheng-ru-he-zhi-zuo-duo-ji-xia-la-lie-biao.html