Try using Data, Validation, under Allow:, choose List, then for

Source, indicate your list (group of cells where you have the

different options you want to appear in the list). Now you should have

a cell that has a little arrow when you click on it.

Now copy to other cells easily by clicking on this cell, Edit, Copy,

then highlight other cells, Edit, Paste Special, Validation, click OK.

MRO (Aimee Fitzgerald) wrote in message news:…

> I am not a frequent user of Excel, so this may be an obvious question.

> If so, I apologize in advance. (but please help me!)


> I need to take an existing spreadsheet and add drop down menus for

> entering data for items that are already pre-determined. We’ve taken

> a questionnaire that was developed in Excel and I just need to get the

> responses back into it quickly. We have a large volume that needs to

> be entered, and it seems that this is the best way to avoid a lot of

> human error.


> For example, the questionnaire might have a range of ages: 18-25,

> 26-35, 36-45 etc. The respondent selected 36-45. I want that to be an

> option in a drop-down so it can be selected and move on to the next

> one.


> The only thing I’ve seen in Excel is the Forms tool buttons, but they

> seem to be related only to the entry of entirely new data – we just

> want to add a few things to an existing spreadsheet.


> Thanks very much in advance for any assitance you can provide.


> Aimee 🙂


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s