remove a drop-down list in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
if its a combo from the forms toolbar right click on it and cut...and dont
paste...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dependent drop down dynamic range formula, off sheet. 7
Formatted cell column in drop down list 1
Drop Down with dynamic named range offsheet source list 14
customize drop-down box 1
use v lookup from a drop down list 5
can not see anything in drop down list 1
drop down lists 1
Create a drop-down list from a range of cells 2

Back
Top