Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a List in Excel 2000 | Excel Worksheet Functions | |||
Excel Drop Down List Formatting | Excel Discussion (Misc queries) | |||
drop down list in Excel | Excel Worksheet Functions | |||
How can I create a monthly calender as a drop down list in excel? | Excel Discussion (Misc queries) | |||
How do I set up a drop down box in Excel with a list of options f. | Excel Discussion (Misc queries) |