Change Insert Sheet Defaults Hi, I have customised my book.xltx workbook so it h

Question

Change Insert Sheet Defaults

Hi,

I have customised my book.xltx workbook so it has only sheet1 and has formatting etc. to my requirements.

When I need an extra worksheet I use right click on sheet1 and make a copy to the current workbook.

I do this because it then has the formatting etc. as my book.xltx.

If I use the plus icon to insert the new worksheet it does not have my book.xltx style.

My Question

Is there a procedure for changing the default insert new worksheet via the plus icon to match my book.xltx style?

Appreciate any assistance.

Thanks !!

Explanation / Answer

Hi..

Make a copy of your Book.xltx template in the same folder and name it Sheet.xltx.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.