Drop-down list
 

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.

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 he

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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.
.

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

"Jason Morin" wrote:

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 he

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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.
.