Copying template from one worksheet to another



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.)?



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