Drop-down list

[Ted]

I created a drop-down list in a separate sheet in my workbook. I named it
Vehicles. Now I want to add to the list, but I can't figure out how to do it.
I know ig must be so easy, but I'm stumped. Please help.

 

[Jason Morin]

If it's a one-time occurrence, you can press Ctrl+F3,
click on the name, and extend the formula. Otherwise, I
would make the range dynamic. You can learn how to do
that here:

http://www.contextures.com/xlNames01.html#Dynamic

HTH
Jason
Atlanta, GA

 

[Ted]

That's exactly what I needed to know. Whoever you are, a thousand thanks.