N
ntrain22
Could someone assist me with adding drop downs to my spreadsheet? How d
I do it
I do it
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Lovelock, David
ntrain - See my post "Default Values" the spreadsheet there has dro
down boxes on it. Download the spreadsheet and you will be able to se
what I did. Basically for each box I created a lsit onthe second sheet
Then When I right Click on the box I got to format control, from ther
I can control the cells to be browsed for the values.
Good Luc
down boxes on it. Download the spreadsheet and you will be able to se
what I did. Basically for each box I created a lsit onthe second sheet
Then When I right Click on the box I got to format control, from ther
I can control the cells to be browsed for the values.
Good Luc
D
Dan E
Ntrain,
Their are three different kinds of dropdowns. Here's a link on
how to make the "Data Validation" style.
http://www.contextures.com/xlDataVal01.html
If this doesn't suityour needs, please post back with an
explanation of what it is you need to accomplish. The other
two types of dropdowns come from the "Forms Toolbar" and
the "Control Toolbox" and all function slightly differently.
Dan E
Their are three different kinds of dropdowns. Here's a link on
how to make the "Data Validation" style.
http://www.contextures.com/xlDataVal01.html
If this doesn't suityour needs, please post back with an
explanation of what it is you need to accomplish. The other
two types of dropdowns come from the "Forms Toolbar" and
the "Control Toolbox" and all function slightly differently.
Dan E
N
ntrain22
I tried the aforementioned method, but it did not work for me. I got a
far as creating the list that I was trying to put in the drop down men
and I selected the cell that I wanted the menu to be located in, but
cannot find an option that will allow me to create this. May I hav
more help please
far as creating the list that I was trying to put in the drop down men
and I selected the cell that I wanted the menu to be located in, but
cannot find an option that will allow me to create this. May I hav
more help please
D
Dan E
ntrain22,
From the menu's choose
Data -> Validation and a form will pop-up
under the "Settings" tab in the "Allow" field choose "List"
in the "Source" field enter your list (ie. =$A$1:$A$10)
Your list must be on the same page, unless you use a
named range.
Once again, i'm sure this is all documented here
http://www.contextures.com/xlDataVal01.html
Dan E
From the menu's choose
Data -> Validation and a form will pop-up
under the "Settings" tab in the "Allow" field choose "List"
in the "Source" field enter your list (ie. =$A$1:$A$10)
Your list must be on the same page, unless you use a
named range.
Once again, i'm sure this is all documented here
http://www.contextures.com/xlDataVal01.html
Dan E
L
Lovelock, David
I am confused as to what step you are on. Did you create the Box itsel
(even if it is empty). If so, and you have created your list o
choices. You should be able to right click on the Box and go into th
Format Control menu. Are you this far? E-mail me if you get a chanc
I'll be working from 7:00 a.m. to 3:30 p.m on Wednesday and should se
the e-mail before i see the follow up post. (e-mail address removed)
(even if it is empty). If so, and you have created your list o
choices. You should be able to right click on the Box and go into th
Format Control menu. Are you this far? E-mail me if you get a chanc
I'll be working from 7:00 a.m. to 3:30 p.m on Wednesday and should se
the e-mail before i see the follow up post. (e-mail address removed)