How do I add drop down choices to a spreadsheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have figured out how to get drop downs in my spreadsheet but I can not
figure out how to be able to re-use the same one in different boxes over
again. When I put in a selection from a drop down, it takes it away from
being one of the choices on my list for the next one. I hope someone can
help! I am very frustrated!
 
I want to be able to reuse the entries over and over. It is a spreadsheet of
codes and the codes may need to be entered more than once.

Wendy
 
You can use a named range as the source, as described here:

http://www.contextures.com/xlDataVal01.html

Then, the list items won't disappear as you move down the worksheet.

Or, if you select a range on the worksheet, use absolute references, so
the range won't adjust as you move down. For example,

instead of:
=A1:A10
use
=$A$1:$A$10
 
Oh, I thought it was the other way.

Just use absolute references in you range, such as $A$1 not A1.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
I have that - this is how I have the range
=$A$1:$E$25
It still doesn't work. I have been working on this for a while and can not
get it to work.
 
Surely you get an error with that, a list must be one row or one column, not
multi in both dimensions.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top