Forum Discussion
aforbes26
Oct 21, 2022Copper Contributor
Drop down list
I would like to create a drop down list that when you select a certain item from the dropdown menu, it has all the data along with it. Does that make sense? For example: Alaska is the item that would...
dscheikey
Oct 21, 2022Bronze Contributor
Hi, if you have Excel 365 then this is possible. You have to create a named area with the name "Alaska" for the content Alaska. Then you have to create a list for your dropdown. This must be text. So write in the cell: '=Alaska
Then you can select this name in the dropdown. There is just the "=" in front of the name.
After the selection, the area spills down.