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