Drop-down menus

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I have been trying all morning to work out how tomake a
drop-down menu in a cell. Is it possible in Windows 98?
 
Yes, While in desired cell go to the menu, click on Data, Validation, Select
List from Allow box and in source box type in either:
Choice1,Choice2,Choice3 <<< For more non-changeable type entry-types
or
First before doing the above type in another area of your worksheet say
In K1 Choice1
In K2 Choice2
In K3 Choice3
In this case, in the source box type in =K1:K3
That should work for you..
Good Luck
 
Cheers J, thats worked, but has led me to my next problem.
If I put in a formula such as =IF(B13="Internal",C13,IF
(B13="External",D13,"")), how do I get my result to be the
drop down menus that I have put in C13 and D13? B13 is
also a drop down menu. What I ideally want is a first
drop down menu which will bring up a second drop down menu
depending upon what you picked in the first.
 
Back
Top