(3) Remove the saving path in the Address box, and then paste the following path into the Address box and press the Enter key.Ĭ:\Documents and Settings\%username%\Application Data\Microsoft\Excel\XLSTART (2) Click the Save as type box and specify the Excel Template (*.xltx) from the drop down list (1) Name the new template as Sheet in the File name box Step 4: In the coming Save As dialog box: Step 3: Click the File > Save > Computer > Browse in Excel 2013, or click the File / Office button > Save in Excel 20. Step 2: Remove all worksheets in this workbook, except the worksheet you formatted. Step 1: Create a new workbook, and format one worksheet as you need. Although you change the default workbook template, you have to change the default Excel’s worksheet template in order that new worksheet will apply the specified formats or styles.
