copy worksheet & include all fonts & print settings

T

tbasic

I have a spreadsheet that I use for the year (Jan-Dec). Each month I copy the previous months sheet and rename it to the current month. The problem I am having is I can't seem to keep all the settings for printing to carry over to the next months sheet. I have tried to hold the control key down & select the new sheet and then going to print settings & saying OK. This changes some of the settings, but others are not being carried over. Is there a way to make the new sheet print exactly like the old one?
 
P

Peo Sjoblom

Right click on the sheet tab you want to copy, select "Move or Copy"
check "Create a Copy" and where you want it, click OK. Now rename the sheet
which would have
added a (2) to the name of the sheet. It should keep the settings and
formats

--

Regards,

Peo Sjoblom


tbasic said:
I have a spreadsheet that I use for the year (Jan-Dec). Each month I copy
Click to expand...
the previous months sheet and rename it to the current month. The problem I
am having is I can't seem to keep all the settings for printing to carry
over to the next months sheet. I have tried to hold the control key down &
select the new sheet and then going to print settings & saying OK. This
changes some of the settings, but others are not being carried over. Is
there a way to make the new sheet print exactly like the old one?
 
L

Lady Layla

What is not carrying over? When I do as Peo suggests, everything comes over
exactly as the original sheet dictates


: I have done this but all the print setting do not carry over with the sheet.
 
Top