| 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) | |||
Hybrid Mode
