How Do I Set Up An Excel Box Template

Create your own Excel template

Past Kelly 50. Williams, CPA, Ph.D.

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

A. You lot can easily make this format your "default" in Excel by creating a template using this format and choosing that template when you open up a new document in Excel. Every time y'all open the template, that format volition already be applied.

techqa-1

You can brand templates for all sorts of preferred "defaults." Creating personal templates tin can have many uses, such every bit designing an invoice template specifically for your concern, setting upwards a standard financial statement template, and creating a budget template unique to your expenses.

To create an Excel template, open a blank Excel document and add the information or formatting you would like to be included in the template. Or, if you already have a workbook that contains the information or formatting, open the workbook. For our case, open a new, blank Excel workbook. Click the Select All button in the upper left corner of the spreadsheet to the left of all columns and above all rows (equally shown in the screenshot below).

techqa-2

This will select all cells in the spreadsheet. Right-click anywhere in the cells and choose Format Cells. Nether Category:, select Number; cull ii for Decimal Places:; put a checkmark side by side to Apply thou Separator (,); and select (i,234.x) nether Negative numbers:. The Format Cells window should now await like the screenshot. Click OK .

If this is the commencement fourth dimension a personal template has been created on this device, y'all will need to define the path where these templates volition be stored. To do that, become to File, Options, and cull Save. Under Salve workbooks, in that location is a line that says Default personal templates location:. The path defined is usually C:\Users\[UserName]\Documents\Custom Office Templates. You lot will need to do this footstep only one time.

Save your template by going to File, Save As, and choose the path that is defined in the step above. Name the template and relieve as an Excel Template (*.xltx). Close the template.

When y'all desire to use your template, go to File, New. You volition see the words Function and Personal about halfway down the page. Choose Personal and then select the template you would like to utilise. Once you have selected this template, it volition be pinned correct adjacent to the Bare Workbook option that you lot come across when you click File. At this point, information technology is simply equally easy to select your template as it is to select a new workbook, just yous don't have to start from scratch.

You lot can view the video demonstration for creating this template below.

Almost the writer

Kelly L. Williams, CPA, Ph.D., MBA, is an associate professor of accounting at the Jones College of Business at Middle Tennessee State University.

Submit a question

Do yous take technology questions for this cavalcade? Or, after reading an answer, practice yous accept a amend solution? Transport them to jofatech@aicpa.org. We regret being unable to individually respond all submitted questions.