Excel 'Popup'
Posted by Thomas Rector on October 23, 2001 6:40 PM
Is there any way to set a 'pick list' to popup for
selection when any cell in a column (length 40 rows)
is selected ?
Ex: When I select cell F15, how can I get a pick list to popup without doing a right click, then again
on cell F16, then F17, etc;
Posted by Juan Pablo on October 23, 2001 7:32 PM
Use data validation. Select the entire column, go to Data - Validation and select "List". In there do either:
1. Select a range that has your "pick list", should be in the same sheet, can be in a hidden column o row.
2. Type your items separated by commas, that is: item1,item2,item3,item4
3. If your pick list is in another sheet, you can name it (Edition, Names, Define or Select the range and click on the white box on the left of the formula bar), something like PickList. Now in data validation put, in the space you have
=PickList
That way you should get your pick list in every cell in that column.
Juan Pablo
