This can be maddeningly complex, depending on which platform and version of Excel you use. If you get frustrated and can't make things work, you can set your own startup folder manually, as described below.
A template can hold many custom options. Here are a few examples of settings that can saved in a workbook template:. Remember: these setting only apply to new workbooks created after a custom template file is installed. The key is to put your template file into this folder so that Excel will find it. Here are some common locations:. The startup path will appear below the command.
If you can't find Excel's startup directory, or if burying your template deep in an application hierarchy just seems wrong, you can tell Excel to look in your own startup folder by setting an option as follows:.
Telling Excel about your own startup folder After you go through the steps to set up a default template, make sure you test to confirm your template is being used.
One easy way to do this is to temporarily give cell A1 in your template a bright yellow or orange fill. That way, you can immediately see if your custom template is being used. In the opening Word Options dialog box, click the Advanced in the left bar, and then click the File Locations button in the General section.
In the coming File Locations dialog box, click to select the User templates in the File types box, and click the Modify button. Now you get into the Modify Location dialog box, find out and select a folder, and then click the OK Button. How to make a read-only template in Excel? How to create a bell curve chart template in Excel? How to create a Gantt chart template in Excel? How to create a Macro-enabled template in Excel? Note: The other languages of the website are Google-translated.
Microsoft PnP. Healthcare and Life Sciences. Internet of Things IoT. Enabling Remote Work. Small and Medium Business. Humans of IT. Green Tech. MVP Award Program. Video Hub Azure. Karan Karan There are multiple places to check.
Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses.
0コメント