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 |
#1
|
|||
|
|||
Hidden Drop Down List
I can't see the drop down list that I have created. Any ideas why?
|
#2
|
|||
|
|||
Hidden Drop Down List
hi
is it data validation? you can't see it untill you click in the cell. regards FSt1 "Angela" wrote: I can't see the drop down list that I have created. Any ideas why? |
#3
|
|||
|
|||
Hidden Drop Down List
The list was created using Validation, however when I click on the cell where
the drop down list should appear, nothing. It doesn't give the drop down list. "FSt1" wrote: hi is it data validation? you can't see it untill you click in the cell. regards FSt1 "Angela" wrote: I can't see the drop down list that I have created. Any ideas why? |
#4
|
|||
|
|||
Hidden Drop Down List
Do you have the In-Cell Dropdown checkbox, checked?
"Angela" wrote: The list was created using Validation, however when I click on the cell where the drop down list should appear, nothing. It doesn't give the drop down list. "FSt1" wrote: hi is it data validation? you can't see it untill you click in the cell. regards FSt1 "Angela" wrote: I can't see the drop down list that I have created. Any ideas why? |
#5
|
|||
|
|||
Hidden Drop Down List
Yes it is. All seems to be ok, however I'm just not seeing the drop down box.
"akphidelt" wrote: Do you have the In-Cell Dropdown checkbox, checked? "Angela" wrote: The list was created using Validation, however when I click on the cell where the drop down list should appear, nothing. It doesn't give the drop down list. "FSt1" wrote: hi is it data validation? you can't see it untill you click in the cell. regards FSt1 "Angela" wrote: I can't see the drop down list that I have created. Any ideas why? |
#6
|
|||
|
|||
Hidden Drop Down List
Check this setting:
ToolsOptionsView tabObjectsShow All -- Biff Microsoft Excel MVP "Angela" wrote in message ... Yes it is. All seems to be ok, however I'm just not seeing the drop down box. "akphidelt" wrote: Do you have the In-Cell Dropdown checkbox, checked? "Angela" wrote: The list was created using Validation, however when I click on the cell where the drop down list should appear, nothing. It doesn't give the drop down list. "FSt1" wrote: hi is it data validation? you can't see it untill you click in the cell. regards FSt1 "Angela" wrote: I can't see the drop down list that I have created. Any ideas why? |
#7
|
|||
|
|||
Hidden Drop Down List
Did you ever get this resolved? I'm having the same problem in Excel 2007.
The 'In-cell dropdown' option is checked, and 'For objects-show all' is checked (in Office Button-Excel options-Advanced-Display options for this workbook). I can see the dropdown lists on one worksheet but not on another, so it must be something cell or worksheet specific, rather than a setting for the whole workbook. (?) Jey "T. Valko" wrote: Check this setting: ToolsOptionsView tabObjectsShow All -- Biff Microsoft Excel MVP "Angela" wrote in message ... Yes it is. All seems to be ok, however I'm just not seeing the drop down box. "akphidelt" wrote: Do you have the In-Cell Dropdown checkbox, checked? "Angela" wrote: The list was created using Validation, however when I click on the cell where the drop down list should appear, nothing. It doesn't give the drop down list. "FSt1" wrote: hi is it data validation? you can't see it untill you click in the cell. regards FSt1 "Angela" wrote: I can't see the drop down list that I have created. Any ideas why? |
#8
|
|||
|
|||
Hidden Drop Down List
See if this helps:
http://contextures.com/xlDataVal08.h...rowsNotVisible -- Biff Microsoft Excel MVP "Jey" wrote in message ... Did you ever get this resolved? I'm having the same problem in Excel 2007. The 'In-cell dropdown' option is checked, and 'For objects-show all' is checked (in Office Button-Excel options-Advanced-Display options for this workbook). I can see the dropdown lists on one worksheet but not on another, so it must be something cell or worksheet specific, rather than a setting for the whole workbook. (?) Jey "T. Valko" wrote: Check this setting: ToolsOptionsView tabObjectsShow All -- Biff Microsoft Excel MVP "Angela" wrote in message ... Yes it is. All seems to be ok, however I'm just not seeing the drop down box. "akphidelt" wrote: Do you have the In-Cell Dropdown checkbox, checked? "Angela" wrote: The list was created using Validation, however when I click on the cell where the drop down list should appear, nothing. It doesn't give the drop down list. "FSt1" wrote: hi is it data validation? you can't see it untill you click in the cell. regards FSt1 "Angela" wrote: I can't see the drop down list that I have created. Any ideas why? |
#9
|
|||
|
|||
Hidden Drop Down List
Hi,
Thanks for the link. It wasn't any of those, but on a whim I just copied everything to a new worksheet, and now it all works fine! I tried copying back to the original worksheet, and still no list. Very odd, but I'm not going to loose any sleep trying to figure it out... its all good now. Jey "T. Valko" wrote: See if this helps: http://contextures.com/xlDataVal08.h...rowsNotVisible -- Biff Microsoft Excel MVP "Jey" wrote in message ... Did you ever get this resolved? I'm having the same problem in Excel 2007. The 'In-cell dropdown' option is checked, and 'For objects-show all' is checked (in Office Button-Excel options-Advanced-Display options for this workbook). I can see the dropdown lists on one worksheet but not on another, so it must be something cell or worksheet specific, rather than a setting for the whole workbook. (?) Jey "T. Valko" wrote: Check this setting: ToolsOptionsView tabObjectsShow All -- Biff Microsoft Excel MVP "Angela" wrote in message ... Yes it is. All seems to be ok, however I'm just not seeing the drop down box. "akphidelt" wrote: Do you have the In-Cell Dropdown checkbox, checked? "Angela" wrote: The list was created using Validation, however when I click on the cell where the drop down list should appear, nothing. It doesn't give the drop down list. "FSt1" wrote: hi is it data validation? you can't see it untill you click in the cell. regards FSt1 "Angela" wrote: I can't see the drop down list that I have created. Any ideas why? |
Thread Tools | |
Display Modes | |
|
|