:"Excel beginners: how to quickly create a multi-level drop-down menu"-Table skills免费ppt模版下载-道格办公

"Excel beginners: how to quickly create a multi-level drop-down menu"

Multi-level drop-down menus can not only save input efficiency, but also ensure the standardization of data. The following are the steps to implement a multi-level drop-down menu: 1. When the amount of data is small, you can directly use the drop-down list to enter manually. The operation steps are as follows: - Select the area where you want to add a multi-level list, and click "Drop-down List" under the "Data" tab. - In the "Drop-down List" dialog box, click New Manual Input Option in the upper right corner. 2. The secondary drop-down menu can display the corresponding option list based on the content of the previous cell. The operation steps are as follows: - First, you need to prepare a correspondence table between cities and jurisdictions so that you can read the corresponding jurisdictions based on the city. - Then, select all the corresponding areas, press the key combination "Ctrl+G" to bring up the positioning dialog box, and select Constant to confirm. - Then click the "Specify" button under the "Formula" tab, select the first position, and complete the batch definition of names. - 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. - Select the jurisdiction column, enter the "Data Validity" dialog box, select "Sequence", enter the formula `=INDIRECT(B2)` in the source, and confirm. 3. Three-level drop-down menus. It should be noted 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". The steps are as follows: - Repeat the previous steps, first locate and then define the name via the "Assign" button. - Finally, in the "Data Validity" dialog box, select the sequence and enter `=INDIRECT(B2&C2)` as the source. Please follow the above steps to implement the function of multi-level drop-down menu. If you need to see the specific operation process, you can view the provided GIF animation tutorial.

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/Excel-xin-shou-ru-men-kuai-su-chuang-jian-duo-ji-xia-la-xuan-zhai-cai-dan-ji-qiao.html