Duplicating Excel templates

J

Jeffrey

I have been using a Billing Statement template that I down load and I am
trying to
copy it to another worksheet.
But when I do it does not look like the original.
How do I do this or copy it as a secong page without losing the format?
 
M

Marcelo

hi,

try to click on the spreadsheet name press ctrl and craw

hope this helps
regards from Brazil
Marcelo

"Jeffrey" escreveu:
 
D

Dave Peterson

ctrl-Click on the worksheet tab and drag to the right or left.

You'll be copying the worksheet.

If you meant you want to copy to another workbook, select the worksheet
edit|move or copy sheet|check copy and point at a new/existing workbook.
 
J

Jeffrey

Thanks, that was what I was looking for.
Now one more question, how do tou bring forward the balance from the first
worksheet to the second one.
 
D

Dave Peterson

Maybe???

Can you use a formula like:

=if(sheet2!a1="","",sheet2!a1)

(the balance has to be in the same location if you use the address)

Maybe define a name for that cell with the balance (insert|Name|Define)

=if(myBalance="","",myBalance)

Personally, I like to keep all my data in one worksheet.
 
J

Jeffrey

Thanks that helps.

Dave Peterson said:
Maybe???

Can you use a formula like:

=if(sheet2!a1="","",sheet2!a1)

(the balance has to be in the same location if you use the address)

Maybe define a name for that cell with the balance (insert|Name|Define)

=if(myBalance="","",myBalance)

Personally, I like to keep all my data in one worksheet.
Click to expand...
 
Top