how do I add a drop-down menu to a pre-populated cell?

[Advice Pro]

I know how to create a drop-down menu for a blank cell, but how about for a filled one? E.g. I Could you have a cell pre-populated with the word PC and I do want to make a drop-down menu of companies like Hewlett-Packard, Dell, Gateway, etc.

Is it possible to extract the contents of a drop-down menu?

 

[macness]

Sounds like you're talking about data validation.

You can preselect the value of a validation list like in your example your data validation 'list' field would read

PC, HP, Dell, Gateway

you can actually go the other way around - create a content list somewhere and make it named range and reference it in your validation list

=PCs

for example.

does that help?