S sowetoddid Nov 12, 2003 #1 How can I create a pull down menu to choose the contents of a cell? want to restrict the users input to 5 different values
How can I create a pull down menu to choose the contents of a cell? want to restrict the users input to 5 different values
B Bob Phillips Nov 12, 2003 #3 Take a look at Data Validation in Help. Debra Dalgleish has a good web page on it http://www.contextures.com/xlDataVal01.html -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
Take a look at Data Validation in Help. Debra Dalgleish has a good web page on it http://www.contextures.com/xlDataVal01.html -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
G Guest Nov 13, 2003 #4 Go to Data>Validation and select LIST under the "Allow" window and in the source box type your 5 items you want people to select from each separated by a coma Make sure your in the cell where you want the validation to show up ----- Bob Phillips wrote: ---- Take a look at Data Validation in Help Debra Dalgleish has a good web page on i http://www.contextures.com/xlDataVal01.htm - HT Bob Phillip ... looking out across Poole Harbour to the Purbeck (remove nothere from the email address if mailing direct
Go to Data>Validation and select LIST under the "Allow" window and in the source box type your 5 items you want people to select from each separated by a coma Make sure your in the cell where you want the validation to show up ----- Bob Phillips wrote: ---- Take a look at Data Validation in Help Debra Dalgleish has a good web page on i http://www.contextures.com/xlDataVal01.htm - HT Bob Phillip ... looking out across Poole Harbour to the Purbeck (remove nothere from the email address if mailing direct
