一级下拉菜单
Choose the area of State B3:B13 (including title)
Click Data > Data Validation (Data Tools) > Data Validation
At the window of Data Validation,
Allow: List
Source: E3:G3 (state category)
Click OK
二级下拉菜单
Choose the area of E3:G9 (including title)
Click Ctrl + G (or Home > Editing > Find & Select > Go to Special)
Click Special
Click Constants, then click OK
Go to Formulas > Define Name > Create Names from Selection
Make sure only Top row was click, then click OK
Choose the area of City C3:C13 (including title)
Click Data > Data Validation (Data Tools) > Data Validation
At the window of Data Validation,
Allow: List
Source: =indirect(B3) <Remove $>
没有评论:
发表评论
注意：只有此博客的成员才能发布评论。