Making a drop down menu

  • Thread starter Thread starter lance
  • Start date Start date
L

lance

I am trying to make a cell that will have a drop down menu
with certain options to select from. Ex. Cell A1 dropdown
options would be yes or no. The problem is that I dont
remember where to start the process at to make the menu,
I've only done it once previously. Any help would be
appreciated. Thanks
 
Lance, sounds like Data Validation, have a look here
http://www.contextures.com/xlDataVal01.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
Hi Lance,

You want Data Validation.

It is under the Data menu and is straight forward for Yes/No options.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top