Simple Question, How to create a default Worksheet

tomlinsn

Board Regular
Joined
Jan 25, 2011
Messages
74
I've done this before, but struggling with the details of how. I have created a default worksheet that opens when Excel starts stored in my XLSTART directory. I need to create a default worksheet so that when I insert a sheet, the new sheet is formatted as I intended. I have tried saving as a template (Sheet.xltx) and stored in the Custom Office Templates folder, but Excel does not insert this formatted sheet when I click insert sheet on the worksheet tabs.

Please help and thank you in advance.
Tom
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Create a single-sheet template and save as Sheet.xltx in XLSTART. Mine is the same file as Book.xltx.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,214,821
Messages
6,121,755
Members
449,049
Latest member
excelknuckles

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top