dropdown list contains 5 items want to add 100 how
 

I have an existing dropdown list containing 5 rows with data ,I want to add
100 more items how do i do so thx vince

dropdown list contains 5 items want to add 100 how
 

Click on Data | Validation and under Allow click on List and then
adjust the range of your data in the Source box.

Hope this helps.

Pete

On Apr 30, 11:07*am, wojick wrote:
I have an existing dropdown list containing 5 rows with data ,I want to add
100 more items how do i do so thx vince