Page Set-up

  • Thread starter Thread starter Staurt Steven
  • Start date Start date
S

Staurt Steven

I want to set up different worksheets to print, by doing
the following:

Having them centred vertically and horizontally
Have them fit to 1 page wide by 1 tall
Have the Header showing "&Tab"

How do I do this for more than 1 sheet at a time????
 
Hi

Group the sheets (select each while holding Ctrl) you want to change and
change the settings on one. It will copy the settings to the rest for you!
Don't forget to ungroup the sheets afterwards.
 
You must log in or register to reply here.

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

Print a worksheet to a page 4
Print Fit To Not Working 1
Printing: rows repeating across the top 1
Printing Issue in Excel 2007 1
Printing worksheet to fit "blank" pages tall. 3
Print preview/page set-up is printing 100's of blank pages 2
Setting print area 1
Printing ranges 1

Back
Top