How to find and change default save location of Excel templates?
If you want to export all of personal Excel templates to a new computer, how to find out the Excel templates quickly? If the default saving location is too hard to find out quickly, how to change the default save location? In this article, I will show you detailed ways to find out the default save location of Excel templates, as well as change the default save location of Excel templates.
Change the default save location of Excel 2013’s templates
Some users may think it’s too difficult to remember the default save location of personal Excel templates. Actually, Excel 2013 supports users to change the default save location of Excel templates as following steps:
1. Click the File > Options.
2. In the opening Excel Options dialog box, click the Save in the left bar, and enter or paste your custom save location into the Default personal templates location box.
3. Click the OK button.
Then the default personal Excel templates’ save location is changed to your custom location.
Change the default save location of Excel 2007/2010’s templates
To change the default save location of Excel 2007/2010’s personal templates, you can do as following:
1. Open Microsoft Word Options dialog box:
In Word 2010, click the File > Options;
In Word 2007, click the Office Button > Word Options.
2. 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.
3. In the coming File Locations dialog box, click to select the User templates in the File types box, and click the Modify button.
4. Now you get into the Modify Location dialog box, find out and select a folder, and then click the OK Button.
5. Click two OK buttons to close the File Locations dialog box and Word Options dialog box.
Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
More than 300 powerful features. Supports Office/Excel
2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features
30-day free trial. 60-day money back guarantee.
If you are operating the second method, it does not need to open Microsoft Word at all. Just launch Microsoft Excel, and then click File > Options to open the Excel options dialog box, and then click Save in the left bar.