excel

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Urgent Priority · Version 2002/XP

Loreen has attended:
Excel Intermediate course

Excel

How does one create a drop down menu for a cell to provide a specific answer. For example if it's a multiple choice question.

Edited on Tue 22 Apr 2008, 12:45

RE: Excel

Hi Loreen, Thanks for the post, in answer to your question, a good way of accomplishing this is to use the Data Validation function;
Select a cell or range of cells to which you wish this operation to be used in, Go to the Menu bar and choose Data>Validation.
In the dialog box that opens, from the Allow drop down options choose List.
In the Source text box, enter your list of items separated by a comma (,)
Alternatively if you have a list already in your worksheet and you wish to use it, select the list, or enter in the range references (ie A1:A15,) click OK and you will notice a drop down arrow appear next to a selected cell in your range.
By clicking on the dropdown your list will be displayed, click on on of the items in your list to select.
I hope that has helped, if so please click the resolved link, best regards Pete
Pete Emmerson
Microsoft Office Specialist Master Instructor


 

Excel tip:

Finding cells that have data restrictions

Click anywhere on the worksheet.
On the Edit menu, click Go To.
Click Special.
Click Data validation.
Click All.

View all Excel hints and tips


Server loaded in 0.13 secs.