Worksheet page setup

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

Robin Chapple

I have a worksheet which covers twelve months. I have copied it to a
new worksheet for the new fiscal year.

I have lost the page setup.

Is there a way to copy this as well?

Thanks,

Robin Chapple
 
In the old worsheet you can Select All-->Copy, activate the new sheet and
goto Edit-->Paste Special-->Formats.

HTH,

Smitty
 
Robin

The "worksheet" with 12 months is just a single worksheet in a workbook?

If you copied just the data from that sheet to a new sheet, the page setup will
not go with.

Suggest you right-click on original sheet and "move or copy"

Checkmark "create a copy" and designate where to place it.

Edit>Replace old year dates with new year dates.


Gord Dibben MS Excel MVP
 
Gord.

"Move or Copy" does not appear as an option. "Copy" is there but that
is what I did already.

Robin
 
Back
Top