When you want to customize the default template that Excel uses for new workbooks, you use the template in your XLSTART folder on your hard drive. This is the template that Excel automatically opens whenever you launch the application. Here’s another good tip: You can also use the XLSTART folder to automatically open any workbook(s) you want when Excel starts. In fact, there are two folders that Excel checks for workbooks when you start the program. If any files are found in these folders, Excel opens them.
Your operating system affects the XLSTART folder’s location, so the easiest way to access it is to use your operating system’s built-in Find or Search feature. In addition to the XLSTART folder, you can specify an additional folder that Excel should check.
- Choose Tools | Options from Excel’s menu bar. (In 2010, click File and select Options. In 2007, click the Office button and select Excel Options.)
- Click on the General tab. (In 2007 and 2010, click Advanced, and scroll to the General area.)
- Enter the folder path in the At Startup, Open All Files In text box.
- Click OK.
Course you may be interested in: