Duplicating Excel templates
 

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?

Duplicating Excel templates
 

hi,

try to click on the spreadsheet name press ctrl and craw

hope this helps
regards from Brazil
Marcelo

"Jeffrey" escreveu:

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?

Duplicating Excel templates
 

Please help, this does not make sense or I am missing something.

"Marcelo" wrote:

hi,

try to click on the spreadsheet name press ctrl and craw

hope this helps
regards from Brazil
Marcelo

"Jeffrey" escreveu:

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?

Duplicating Excel templates
 

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.

Jeffrey wrote:

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?

--

Dave Peterson

Duplicating Excel templates
 

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.

"Dave Peterson" wrote:

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.

Jeffrey wrote:

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?

--

Dave Peterson

Duplicating Excel templates
 

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.



Jeffrey wrote:

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.

"Dave Peterson" wrote:

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.

Jeffrey wrote:

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?

--

Dave Peterson


--

Dave Peterson

Duplicating Excel templates
 

Thanks that helps.

"Dave Peterson" wrote:

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.



Jeffrey wrote:

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.

"Dave Peterson" wrote:

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.

Jeffrey wrote:

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?

--

Dave Peterson


--

Dave Peterson