Copying template from one worksheet to another

B

Bustyn

I have created an inventory worksheet with specific column and row
dimensions, company logo, and formulas. It has 25 lines for individual
inventory items. I'm trying to figure out how to copy this worksheet to
another worksheet, yet still maintain the format of the original worksheet.
I can copy and paste to a new worksheet, but I lose the formatting. The new
worksheet appears with the default row and column dimensions, so I have to
manually adjust these dimensions for each new worksheet. Is there a way that
I can copy my original worksheet to additional worksheets, and still maintain
the formatting (cell dimensions, formulas, logo, etc.)?
 
G

Gord Dibben

Don't just select the cells and copy/paste.

Right-click on the sheet tab and "Move or Copy"

Select "create a copy" and OK


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copying excel worksheets to new worksheet 2
Creating a Worksheet 2
Cannot copy worksheet to another file 2
Copying a worksheet to another workbook 6
copying cell contents from one worksheet to another (re-sorted lis 2
copying worksheet including graphs to new worksheet 9
Copying Worksheets 3

Top