Example:
![](https://connie.hk/wp-content/uploads/2019/10/1571710112020-2.jpg)
Added a new sheet and put the push down list on it
![](https://connie.hk/wp-content/uploads/2019/10/1571739853781.jpg)
First, select the whole row
![](https://connie.hk/wp-content/uploads/2019/10/1571710132836-1.jpg)
Data>Data validation
![](https://connie.hk/wp-content/uploads/2019/10/1571710150264-1.jpg)
Change the Cell Range to C2:C
which means the formula will excluded the row 1(header)
![](https://connie.hk/wp-content/uploads/2019/10/1571710208573.jpg)
Click on Criteria box
![](https://connie.hk/wp-content/uploads/2019/10/1571710208573-1.jpg)
Choose the list sheet
![](https://connie.hk/wp-content/uploads/2019/10/1571710222170.jpg)
Highlight the whole row which you want to able to select in the pull down menu, and changed to TaskConstantList!B2:B to skip the header
![](https://connie.hk/wp-content/uploads/2019/10/1571710243968.jpg)
![](https://connie.hk/wp-content/uploads/2019/10/1571710261971.jpg)
Comment feed