remove a drop-down list in excel
 

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.

remove a drop-down list in excel
 

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.

remove a drop-down list in excel
 

if its a combo from the forms toolbar right click on it and cut...and dont
paste...
--
paul

remove nospam for email addy!



"Gord Dibben" wrote:

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.