Copy & Pasting Drop Down Boxes
 

I have a Excel file containing a variety of drop down menus and am wanting to
duplicate these in other cells. When I copy one of these existing cells and
paste it into another it appears on screen, however when I Print Preview or
subsequently Print. the values i have selected in these copied drop down
menus don't appear.

Any Ideas?