Click on Page Layout on the Ribbon
Click on the arrow on the Page Setup group
Click on Options
Click on Paper Tab
Select the Copies you want
Click Ok
Click Ok

"Peggi" wrote:

In Excel 2003 I could set the number of prints I needed in page setup and
that number would print every time. Now my report is working under Excel
2007 and I cannot figure out how to change the default number of prints. Can
anyone help me with this?
--