Web create a template 1. Web click file > open. On the right, you'll see a default personal templates location box where. Web excel 2010 and excel 2007 open the workbook that you want to use as a template. On the file tab, click save as. Web save a workbook as a template. Click your template, and click open. Browse to the custom office templates folder that’s under my documents. Select file > save as. Web on the file menu, click the options command.
Click save, and then under save workbooks, enter the path to the personal templates location in the default personal templates location box. Click your template, and click open. On the file tab, click save as. In the excel options window, slick the save category in the left column. Make the changes you want, then. Select file > save as. Click save, and then under save workbooks, enter the path to the personal templates location in the default personal templates location box. Web on the file menu, click the options command. Web create a template 1. Web click file > open. Browse to the custom office templates folder that’s under my documents.
