If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
How can I make a drop down box visible within a worksheet?
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 datavalidation obviously) You cannot use autofilter for this -- Regards, Peo Sjoblom "Bonnie" wrote in message ... 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. "Peo Sjoblom" wrote: 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 "Bonnie" wrote in message ... 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. "sparrot" wrote: 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. Thanks "Peo Sjoblom" wrote: 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) "skittles_golf" wrote in message ... How do you create a combo box in Excel 2007 -- Jenny "Peo Sjoblom" wrote: You can't using datavalidation, you can if you use a combobox from the control toolbox -- Regards, Peo Sjoblom "skittles_golf" wrote in message ... 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. -- Jenny |
#12
|
|||
|
|||
How can I make a drop down box visible within a worksheet?
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 "Peo Sjoblom" wrote: 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) "skittles_golf" wrote in message ... How do you create a combo box in Excel 2007 -- Jenny "Peo Sjoblom" wrote: You can't using datavalidation, you can if you use a combobox from the control toolbox -- Regards, Peo Sjoblom "skittles_golf" wrote in message ... 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. -- Jenny |
#13
|
|||
|
|||
How can I make a drop down box visible within a worksheet?
Finally- someone who knows what the hell they are saying! BIG thanks from SD
"Bonnie" wrote: 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. "sparrot" wrote: 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. Thanks "Peo Sjoblom" wrote: 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) "skittles_golf" wrote in message ... How do you create a combo box in Excel 2007 -- Jenny "Peo Sjoblom" wrote: You can't using datavalidation, you can if you use a combobox from the control toolbox -- Regards, Peo Sjoblom "skittles_golf" wrote in message ... 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. -- Jenny |
#14
|
|||
|
|||
How can I make a drop down box visible within a worksheet?
How can you do this is Excel 2003?
"Peo Sjoblom" wrote: 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) "skittles_golf" wrote in message ... How do you create a combo box in Excel 2007 -- Jenny "Peo Sjoblom" wrote: You can't using datavalidation, you can if you use a combobox from the control toolbox -- Regards, Peo Sjoblom "skittles_golf" wrote in message ... 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. -- Jenny |
#15
|
|||
|
|||
How can I make a drop down box visible within a worksheet?
ViewToolbarsControl Toolbox
Click on the "Design Mode" Icon and draw your Combobox. Same instructions after that. Gord Dibben MS Excel MVP On Tue, 8 Jul 2008 14:21:00 -0700, Kendra510 wrote: How can you do this is Excel 2003? "Peo Sjoblom" wrote: 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) "skittles_golf" wrote in message ... How do you create a combo box in Excel 2007 -- Jenny "Peo Sjoblom" wrote: You can't using datavalidation, you can if you use a combobox from the control toolbox -- Regards, Peo Sjoblom "skittles_golf" wrote in message ... 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. -- Jenny |
#16
|
|||
|
|||
How can I make a drop down box visible within a worksheet?
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 "Peo Sjoblom" wrote: 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) "skittles_golf" wrote in message ... How do you create a combo box in Excel 2007 -- Jenny "Peo Sjoblom" wrote: You can't using datavalidation, you can if you use a combobox from the control toolbox -- Regards, Peo Sjoblom "skittles_golf" wrote in message ... 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. -- Jenny |
#17
|
|||
|
|||
How can I make a drop down box visible within a worksheet?
That big circular button at the top left in xl2007 is the Office button.
Brainless_in_Boston wrote: 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 "Peo Sjoblom" wrote: 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) "skittles_golf" wrote in message ... How do you create a combo box in Excel 2007 -- Jenny "Peo Sjoblom" wrote: You can't using datavalidation, you can if you use a combobox from the control toolbox -- Regards, Peo Sjoblom "skittles_golf" wrote in message ... 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. -- Jenny -- Dave Peterson |
#18
|
|||
|
|||
How do I remove names from a drop down box?
I'm using 2007 and it's not that easy for some crazy reason!
|
#19
|
|||
|
|||
How do I remove names from a drop down box?
Why not stick with original thread so's people can see what has been suggested
and tried? Gord On Thu, 10 Jul 2008 13:19:03 -0700, Sassy wrote: I'm using 2007 and it's not that easy for some crazy reason! |
#20
|
|||
|
|||
How Do I put items,(names)inside DV dropdown?
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. "Brainless_in_Boston" wrote: 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 "Peo Sjoblom" wrote: 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) "skittles_golf" wrote in message ... How do you create a combo box in Excel 2007 -- Jenny "Peo Sjoblom" wrote: You can't using datavalidation, you can if you use a combobox from the control toolbox -- Regards, Peo Sjoblom "skittles_golf" wrote in message ... 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. -- Jenny |
Thread Tools | |
Display Modes | |
|
|