How to copy page setup

[Robin Chapple]

I need to open a new worksheet for a new year. (The year starts July
1st)

I have copied the previous year worksheet to a blank worksheet in
order to keep the formatting and formulae.

How do I copy the page setup for printing?

Thanks,

Robin Chapple

 

[somethinglikeant]

why not simple save a copy of the previous file strip out all the
detail you don't need and build up to your new template?

just a suggestion

http://www.excel-ant.co.uk

 

[Gord Dibben]

Instead of copying to a blank worksheet, right-click on the sheet and "move or
copy".

Check "create a copy" and "to book".

With the copy active, F5>Specail>Constants, Uncheck the constants to keep like
Text for Titles and OK

Edit>Clear>Contents.

You will be left with formulas and titles and the Print Setup will not have
changed.


Gord Dibben MS Excel MVP