| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hidden Drop Down List
I can't see the drop down list that I have created. Any ideas why?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
| how do i find where a drop down list is hidden so it can be edited | Excel Discussion (Misc queries) | |||
| Open hidden sheets from a drop down list selection | Excel Discussion (Misc queries) | |||
| Drop down list button hidden | Excel Worksheet Functions | |||
Linear Mode
