You can do either.

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

Selec a cell or range of cells and DataValidationClear All.

To move the data to Access, open Access and FileImport from Excel.


Gord Dibben MS Excel MVP

On Tue, 11 Jul 2006 15:43:01 -0700, turtle
wrote:

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.