Home |
Search |
Today's Posts |
#1
|
|||
|
|||
remove a drop-down list
how can I remove drop down lists in a workbook but keep the data in the cell?
|
#2
|
|||
|
|||
When those are data validation lists (an activation button appears right to
active cell), then select the range with them, from Data menu select Validation, and into Allow field select 'Any value'. Arvi Laanemets "C Garrity" <C wrote in message ... how can I remove drop down lists in a workbook but keep the data in the cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
How do I remove items listed in a pivot table drop down list box | Excel Discussion (Misc queries) | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Drop List Referencing | Excel Worksheet Functions |