Excel - Problem w/ printing more than one worksheet with same sett



As an intermediate user with Excel, I know how to setup a worksheet(s) print
settings. The problem seems to lie in the Excel 2007 print setup for
multi-worksheet prints from a workbook.

It seems that once you have printed any single worksheet and selected print
settings (color/staple/resolution/page breaks/etc.) those print setting seem
to override any new settings you input when printing multiple sheets from a
workbook. Each sheet of the selected workbook prints according to the last
way you printed a specific sheet so every sheet comes out different.

Is there any option/setting to override the Excel individual sheet Print
Settings memory when printing multiple sheets from a workbook together?
Having to alter each worksheet to match each other one-by-one seems

Thanks for your help in advance.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question