dropdown list contains 5 items want to add 100 how

W

wojick

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
 
P

Pete_UK

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
 
Top