I am having trouble getting all sheets in the workbook to print the same. I
have tried selecting all sheets and setting up my header and footer, margins,
etc. But, when I then go to print preview, only the first sheet in the
workbook has held the settings.