Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why isn't the drop down showing using data validation?
I have created several cells with data validation but one of the worksheets
in my workbook doesn't show the drop down list. I can't figure out why. Any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why isn't the drop down showing using data validation?
Yikes! You've given us absolutely nothing to work with!
These would be a good start: Version of Excel Details of the Data Validations you've set up Differences between the DV's that work and the ones that don't *********** Regards, Ron XL2002, WinXP "IDill95" wrote: I have created several cells with data validation but one of the worksheets in my workbook doesn't show the drop down list. I can't figure out why. Any ideas? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why isn't the drop down showing using data validation?
On certain versions of Excel if you have "Freeze Pane" active the drop downs
will not show. This is a "known issue" according to MS. If the panes are frozen, unfreeze the pane and the drop downs will show. "IDill95" wrote: I have created several cells with data validation but one of the worksheets in my workbook doesn't show the drop down list. I can't figure out why. Any ideas? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why isn't the drop down showing using data validation?
That would be Excel 97
Regards, Peo Sjoblom ebruder wrote: On certain versions of Excel if you have "Freeze Pane" active the drop downs will not show. This is a "known issue" according to MS. If the panes are frozen, unfreeze the pane and the drop downs will show. "IDill95" wrote: I have created several cells with data validation but one of the worksheets in my workbook doesn't show the drop down list. I can't figure out why. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to restore disappeared drop list of data validation? | Excel Discussion (Misc queries) | |||
data validation and drop down lists | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Automatic Data Validation drop down creation | Excel Discussion (Misc queries) | |||
Data Validation - Drop down lists - if then? | Excel Discussion (Misc queries) |