How can I make a drop down box visible within a worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created several Drop Down boxes in a worksheet but I want to make them
visible so people know there is a drop down box there. Right now the arrow
doesn't show until you click on that cell. Please help I am not quite sure
how to format it so the drop down arrow stays.
 
You can't using data>validation, you can if you use a combobox from the
control toolbox
 
Office button > Excel Options, make sure "Show Developer Tab" is selected.
Click the Developer tab > Controls > Insert Combobox from the active x
controls,
right click the drop down and select properties, in that pane that opens.
Put the range with your list in the
listfillrange and the cell you want to link to. Click the design mode button
to get out
of design mode


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)
 
I am not sure what you mean by "Put the range with your list in the
listfillrange and the cell you want to link to" I got to that part and am stumped.
Click to expand...
Thanks
 
If the range is A2:A150 then type that in the listfillrange (click in the
box to the right of the word listfillrange
and type it there then close the properties window)


--


Regards,


Peo Sjoblom
 
Hi Sparrot,

Why not add a comment to the appropriate cells and show the comment. Or you
could format the cells with a different color file or a border, then teach
your users what those formats mean. You could even conditional format the
cells to have a color until the user picks an entry from them.

Cheers,
Shane Devenshire
 
OMG is everyone kidding? all you have to do is click on the cell you want to
have the drop down box arrow appear then go to DATA on the menu toolbar and
click FILTER then Click AUTO FILTER thats it. also make sure u highlight the
information you want to appear in the drop down menu.
 
You might want to check out the original post before you post something

The OP asked

"How do you create a combo box in Excel 2007"

it has nothing to do with autofilter


--


Regards,


Peo Sjoblom
 
Yes i did and that wasn't the original post .. the original post was that she
wanted the drop down box to be visible .. not just when she clicked on the
cell she was on. The combo box was an answer to it then someone asked about
the combo box.
 
OK, explain to me how you would put a visible dropdown in cell A2, H10 and
I20
using autofilter? The OP said she put multiple dropdown boxes (using
data>validation obviously)
You cannot use autofilter for this


--


Regards,


Peo Sjoblom
 
How do I lock down the drop down list values so they don't change from the
control box when selecting an entry?

Your tip was spot on - big thxs
 
How can you do this is Excel 2003?

Peo Sjoblom said:
Office button > Excel Options, make sure "Show Developer Tab" is selected.
Click the Developer tab > Controls > Insert Combobox from the active x
controls,
right click the drop down and select properties, in that pane that opens.
Put the range with your list in the
listfillrange and the cell you want to link to. Click the design mode button
to get out
of design mode


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)
Click to expand...
 
View>Toolbars>Control Toolbox

Click on the "Design Mode" Icon and draw your Combobox.

Same instructions after that.


Gord Dibben MS Excel MVP
 
Peo - you clearly know much more than me. Where is the "Office" button? I
certainly don't see it in my Excel icons...

MD
Boston, MA USA
 
Why not stick with original thread so's people can see what has been suggested
and tried?


Gord
 
I'm starting over from scratch....

So How do I get my info inside the DV drop down list? If anyone knows
please give me step by step instructions.
 
Back
Top