How to copy page setup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robin Chapple - 30 Jul 2006 08:33 GMT

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

Reply to this Message

somethinglikeant - 30 Jul 2006 12:54 GMT

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

> I need to open a new worksheet for a new year. (The year starts July
> 1st)
[quoted text clipped - 7 lines]
>
> Robin Chapple

Reply to this Message

Gord Dibben - 30 Jul 2006 17:05 GMT

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

>I need to open a new worksheet for a new year. (The year starts July
>1st)
[quoted text clipped - 7 lines]
>
>Robin Chapple

Reply to this Message