Print Drop Down List
 

How do you print the values in a drop down list?

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?

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?

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?

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.

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