View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
kmax3 kmax3 is offline
external usenet poster
 
Posts: 1
Default 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
ridiculous.

Thanks for your help in advance.