Can New Sheet Keep Formatting of Current Sheet?

[mike2227]

Hello,

I am wondering if it possible (and if so, how) to keep formatting when creating a new worksheet in excel, similar to a template. For example, I have a sheet with a photo, text, and column headers that I want to keep on all worksheets within this workbook. Ideally, I would like to click on "New Sheet" and have it open a new sheet with this information on it already. Then the user only needs to fill out the fields, rather than copy and pasting all the header information.

I am not sure if this is even possible. Please advise either way.

Thank you in advance for your help.

- Mike

 

[gallen]

Yes this is straight forward.

Manually you would select all cells on the source sheet

Then on the destination sheet you can click the little arrow under 'Paste' on the 'Clipboard' section of the Home tab. Then select 'PasteSpecial' then select 'Formats'

This will only paste the formatting, ignoring any values.

 

[gallen]

If it is a regular occurrence, you canmake your document a single sheet document then goto File>Save as> Template (xltm)

Give it a name and save in the default location.

Then when you open a different workbook you can right-click a tab name and choose "Insert", you should see the template you created, listed there. It will insert that into your current workbook

 

[mike2227]

Thanks Gallen, that does make the process easier. I was hoping for something more automatic though. Like if I save it as a template if there is a way to have the information auto-populate when I create a new sheet. That would be best.

 

[mike2227]

That sounds better, but I can't seem to find it. I created a new document with just the headers and what I want to be on each sheet and saved it as a template. Then when i create a new sheet, right click, and click insert, I see the stock templates but not the one I just made. I saved and closed the template before trying this.

 

[gallen]

That's weird. What version of Office are you using?

When you change the document type to template, does it automatically change the location of the save? (It should do, to something likeC:\Users\YOURUSERNAME\AppData\Roaming\Microsoft\Templates)

Then anything in that folder should show when you click 'insert' after right-clicking a tab name.