remove a drop-down list in excel

T

turtle

I have a worksheet containing drop-down lists. I want to either 1)export the
data to an Access table or 2) remove the drop down and list the drop-down
value when it is pasted into another excel worksheet. Any help is truly
appreciated.
 
G

Gord Dibben

You can do either.

To get rid of drop-down lists.....assuming Data Validation.............

Selec a cell or range of cells and Data>Validation>Clear All.

To move the data to Access, open Access and File>Import from Excel.


Gord Dibben MS Excel MVP
 
Top