View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Worksheet page setup

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.

EditReplace old year dates with new year dates.


Gord Dibben MS Excel MVP

On Thu, 02 Aug 2007 10:38:47 +1000, Robin Chapple
wrote:

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