Formatting all sheets in a workbook to print the same

G

Guest

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.
 
B

Bernie Deitrick

You need to do each sheet individually, or copy the sheet that you have set
up and use it as your sheet template.

HTH,
Bernie
MS Excel MVP
 
G

Gord Dibben

mrreed

Selecting all sheets and setting up the active one as you describe should
definitely set up all selected sheets the same.

You won't be able to set Print Range and Rows to repeat at top.

All else should set up on each sheet.

I tried with some sheet protected and it still worked for all.

Not much help from me<g> Keep trying.


Gord Dibben Excel MVP
 

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

Similar Threads

Consistent print settings across multiple sheets 3
Printing Sheets in a Workbook 3
Problelm with some sheets not printing the borders (lines). 1
Merge Multiple workbook sheets into one workbook 0
How do I copy print formatting to multiple sheets in a workbook? 2
Setting print area for entire workbook 1
Printing options for all sheets in a workbook? 3
Certain worksheets won't print 1

Top