How To Make A Template In Excel

Create your own Excel template

By Kelly L. Williams, CPA, Ph.D.

Q. By far, my preferred number format is this one shown in the screenshot below. How do I make information technology the default format for my worksheets?

A. Yous can easily make this format your "default" in Excel by creating a template using this format and choosing that template when you open a new document in Excel. Every time you open the template, that format will already exist applied.

techqa-1

Yous can brand templates for all sorts of preferred "defaults." Creating personal templates can have many uses, such equally designing an invoice template specifically for your business concern, setting up a standard fiscal statement template, and creating a budget template unique to your expenses.

To create an Excel template, open up a blank Excel document and add the information or formatting you would like to exist included in the template. Or, if y'all already take a workbook that contains the information or formatting, open the workbook. For our case, open a new, bare Excel workbook. Click the Select All push in the upper left corner of the spreadsheet to the left of all columns and above all rows (every bit shown in the screenshot below).

techqa-2

This volition select all cells in the spreadsheet. Correct-click anywhere in the cells and choose Format Cells. Under Category:, select Number; cull 2 for Decimal Places:; put a checkmark adjacent to Use 1000 Separator (,); and select (i,234.x) nether Negative numbers:. The Format Cells window should now wait like the screenshot. Click OK .

If this is the first fourth dimension a personal template has been created on this device, you volition need to define the path where these templates will exist stored. To do that, go to File, Options, and choose Save. Under Save workbooks, in that location is a line that says Default personal templates location:. The path defined is unremarkably C:\Users\[UserName]\Documents\Custom Office Templates. You will demand to do this step but once.

Relieve your template by going to File, Salvage As, and choose the path that is divers in the step in a higher place. Proper noun the template and salve as an Excel Template (*.xltx). Close the template.

When you want to use your template, become to File, New. You will see the words Role and Personal about halfway down the page. Choose Personal and so select the template you would like to employ. Once y'all take selected this template, it will be pinned right next to the Bare Workbook option that you come across when you lot click File. At this point, it is just as piece of cake to select your template every bit it is to select a new workbook, but you lot don't take to outset from scratch.

Yous tin can view the video demonstration for creating this template below.

About the author

Kelly L. Williams, CPA, Ph.D., MBA, is an acquaintance professor of bookkeeping at the Jones College of Business at Center Tennessee Country Academy.

Submit a question

Practise y'all have technology questions for this column? Or, after reading an respond, do you lot have a ameliorate solution? Send them to jofatech@aicpa.org. We regret beingness unable to individually respond all submitted questions.