Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print Drop Down List
How do you print the values in a drop down list?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print Drop Down List
Assuming a Data Validation dropdown list...................
Print the range of cells that are the source for the drop-down list? If you have no range of cells for the source list are using a comma-delimited list, you can CTRL + c in the source dialog box then paste somewhere to print. Gord Dibben MS Excel MVP On Mon, 7 Jul 2008 12:48:00 -0700, brm3 wrote: How do you print the values in a drop down list? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print Drop Down List
Do I feel silly.
Thank you. "Gord Dibben" wrote: Assuming a Data Validation dropdown list................... Print the range of cells that are the source for the drop-down list? If you have no range of cells for the source list are using a comma-delimited list, you can CTRL + c in the source dialog box then paste somewhere to print. Gord Dibben MS Excel MVP On Mon, 7 Jul 2008 12:48:00 -0700, brm3 wrote: How do you print the values in a drop down list? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print Drop Down List
Why?
Sounded like a reasonable request to me. Gord On Mon, 7 Jul 2008 16:28:00 -0700, brm3 wrote: Do I feel silly. Thank you. "Gord Dibben" wrote: Assuming a Data Validation dropdown list................... Print the range of cells that are the source for the drop-down list? If you have no range of cells for the source list are using a comma-delimited list, you can CTRL + c in the source dialog box then paste somewhere to print. Gord Dibben MS Excel MVP On Mon, 7 Jul 2008 12:48:00 -0700, brm3 wrote: How do you print the values in a drop down list? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print Drop Down List
can you print a worksheet's data validation values when you are just
beginning to consider what values to add? For example you are going to interview someone before setting up some entries and you wanted a hard copy will the allowed values as a reminder for all of the validated fields. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print Drop Down List
I'd put the list on a separate worksheet and then print from there.
Debra Dalgleish has instructions he http://contextures.com/xlDataVal01.html jlivings3 wrote: can you print a worksheet's data validation values when you are just beginning to consider what values to add? For example you are going to interview someone before setting up some entries and you wanted a hard copy will the allowed values as a reminder for all of the validated fields. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Items in Drop Down Filter List | Excel Discussion (Misc queries) | |||
Print each drop-down list selection | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
How can I print a drop down list | Excel Worksheet Functions | |||
How do I change the size of the print in a drop down list? | Excel Discussion (Misc queries) |