Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

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.

Find out the default save location of Excel templates

Change the default save location of Excel 2013’s templates

Change the default save location of Excel 2007/2010’s templates

One click to open folder which contains active workbook with this workbook selected

To quickly open the folder/directory containing current workbook, and have current workbook selected in the opening folder, please try Kutools for Excel’s Open Containing Folder utility. Full Feature Free Trial 30-day!

ad open containing folder 1

Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
  • Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
  • More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
  • Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
  • Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
  • Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
  • Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
  • More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.

arrow blue right bubbleFind out the default save location of Excel templates

To find out default save location of your personal Excel templates, just copy and paste the following path into the Address box of a folder window:

Excel 2013’s personal templates: C:\Users\%Username%\Documents\Custom Office Templates

Excel 2007/2010’ templates: C:\Users\%username%\AppData\Roaming\Microsoft\Templates

For the default Excel template which is applied automatically when creating a new workbook, its default save location is as following:

C:\Documents and Settings\%username%\Application Data\Microsoft\Excel\XLSTART


arrow blue right bubbleChange 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:

Step 1: Click the File > Options.

Step 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.

doc template default save location 1

Step 3: Click the OK button.

Then the default personal Excel templates’ save location is changed to your custom location.


arrow blue right bubbleChange 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:

Step 1: Open Microsoft Word Options dialog box:

  1. In Word 2010, click the File > Options;
  2. In Word 2007, click the Office Button > Word Options.

Step 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.

doc template default save location 2

Step 3: In the coming File Locations dialog box, click to select the User templates in the File types box, and click the Modify button.

doc template default save location 3

Step 4: Now you get into the Modify Location dialog box, find out and select a folder, and then click the OK Button.

doc template default save location 4

Step 4: Click two OK buttons to close the File Locations dialog box and Word Options dialog box.


arrow blue right bubbleRelated articles:


Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • 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.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Gilles · 1 years ago
    Please can you underline or place in bold "Microsoft Word" on the Step 1 line of : "Change The Default Save Location Of Excel 2007/2010’S Templates"

    Because it realy not natural to go in the options of Word to solve a problem of Excel; And the same menu exist on Excel so I had pass a little time to find where I'd made a mistake.

    But I say to you a good thanks for a tric I was looking for a long time ago in France and didn't found anything, so thanks agane.
    • To post as a guest, your comment is unpublished.
      Tang Kelly · 1 years ago
      Hi Gilles,
      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.