Copying template from one worksheet to another

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

 

[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

 

[Bustyn]

Bless you. Just what I needed. Thank you very much.