Contact
12 programs
Explore the site

Microsoft Excel · Workbook essentials · Beginner

Create, save and reuse a workbook template in Excel

Create, save and reuse a workbook template in Excel with a complete practice example, expected results and recovery checks.

Official documentation reviewed; example logic independently checked; native Excel execution not performed · Editorial standards

Quick answer: Prepare a clean workbook, export it as an Excel template, then create a new workbook through File → New → Personal. Save each completed instance as its own XLSX file so the template remains a reusable starting point.

Version and platform: Microsoft 365 Excel for Windows desktop; Mac, Excel for the web and Excel 2013 interfaces not covered. Use a disposable workbook for the exercise.

Build a template that contains structure, not last month’s data

In a new workbook, create a sheet named Request. Put Item, Quantity, Unit cost and Total in A1:D1. Enter Notebook, 2 and 4.5 in A2:C2, then =B2*C2 in D2. The result should be 9. Bold the headings and format Unit cost and Total as currency. Put “Enter one request per workbook” in A4. This is a small reusable request form, not a shared database.

Test the formula before cleaning the example: change B2 to 4 and expect 18. Then clear the sample item and set B2:C2 to zero, leaving D2’s formula intact. The blank template should produce zero, not retain the example purchase. Remove any real names, comments, links or confidential sample records before turning a production workbook into a template.

Save the template in the documented location

These steps are for Excel for Microsoft 365 on Windows. The cited template workflow also lists current perpetual Windows versions; it is not a Mac or browser template-gallery walkthrough.

  1. If personal templates have not been configured, open File → Options → Save. Inspect Default personal templates location. Microsoft’s usual example is the user’s Documents\Custom Office Templates folder; use a location you own and can write to, not someone else’s path.
  2. Set that location if necessary and confirm with OK. This is a local Excel setting, not a cloud sharing permission.
  3. With the clean Request workbook open, choose File → Export → Change File Type.
  4. Under Workbook File Types, double-click Template. Name it Request-form and save it in the configured personal-template folder. The ordinary macro-free template type uses the XLTX extension.
  5. Close the saved template. Do not start filling the first real request into the template itself.

Create and validate two independent instances

Choose File → New → Personal and double-click Request-form. Excel creates a new workbook based on it. Enter Pens, 3 and 1.25 in A2:C2; D2 should become 3.75. Save this instance as request-pens.xlsx.

Create another workbook from the same template. Before entering anything, check that A2 is blank, B2:C2 contain zeros and D2 still contains the multiplication formula. Now enter Folders, 5 and 2; expect 10. Save it as request-folders.xlsx. Reopen request-pens.xlsx and confirm its result is still 3.75. The two requests should not share their input cells.

This changed-input test catches the common mistake of editing a single ordinary workbook repeatedly and calling it a template. The template supplies structure; it is not supposed to keep each instance synchronized with later changes to other instances.

When the template is missing or stale

If Personal does not show the file, check the configured template location and where the template was actually saved. A workbook sitting elsewhere with an XLSX extension is not evidence that the Personal template workflow succeeded. If a new instance contains last month’s inputs, clean the template and create another fresh instance to verify the correction. Do not erase the only completed request while fixing the reusable original.

Keep versioned template copies when changing formulas. Existing saved workbooks are separate files and should be reviewed independently; a corrected template is not proof that old requests were corrected. For storage-format decisions, distinguish an ordinary XLSX instance from the XLTX starting file, and use a macro-enabled template only if the workbook genuinely requires macros.

Official references

Documentation snapshots retrieved 20 October 2026. These instructions and example checks are documentation-based; no native Excel run or application screenshot is claimed.