Sweedler
Board Regular
- Joined
- Nov 13, 2020
- Messages
- 114
- Office Version
- 2016
- Platform
- Windows
- MacOS
Hello
So I am working on a document that is heavily using Dependent Drop down menus. I think I have in the order of 50 named ranges that all can be activated based on previous choices.
What I would like to do is have the word "choose" at the top of each drop down range without needing to add it into each of the already named 50 ranges. Does anyone have any idea how I might go about doing that?
So I am working on a document that is heavily using Dependent Drop down menus. I think I have in the order of 50 named ranges that all can be activated based on previous choices.
What I would like to do is have the word "choose" at the top of each drop down range without needing to add it into each of the already named 50 ranges. Does anyone have any idea how I might go about doing that?