英语翻译不要软件翻译的,原文为：Creating a TemplateA template is a workbook that contains text (such as column and row labels) ,formulas,macros,and formatting you use repeatedly.Once you save a workbook as a template,it provides a model

英语翻译不要软件翻译的,原文为：Creating a TemplateA template is a workbook that contains text (such as column and row labels) ,formulas,macros,and formatting you use repeatedly.Once you save a workbook as a template,it provides a model
英语翻译
不要软件翻译的,原文为：
Creating a Template
A template is a workbook that contains text (such as column and row labels) ,formulas,macros,and formatting you use repeatedly.Once you save a workbook as a template,it provides a model for creating a new workbook without your having to reenter standard data.Excel provides several templates on the Spreadsheet Solutions tab of the New dialog box .In most cases,though,you'll probably want to create your own template from a worksheet you use regularly.When you save a file as a template,the original workbook remains unchanged.Jim plans to use the same formulas ,titles,frozen panes,and row and column labels from the Overtime Hours worksheet for subsequent yearly worksheets.He asks you to delete the extra sheets,the comments,and the data for each month ,and then save the workbook as a template.
1.Click the Sheet2 tab,press [Ctrl] ,click the Sheet3 tab,right-click the Sheet3 tab,click Delete ,then click Delete again.
2.Righg-click cell P11,then click Delete Comment
Now that you've removed the extra sheets and the comment,you'll delete the data on overtime hours.You'll leave the formulas in rows 9,14 and 15,and in columns E,I,M,Q,R,and S,however ,so that another user can simply begin entering data without having to re-create the formulas.
3.Press [Ctrl] ,select the ranges B5:D8,B10:D13,F5:H8,F10:H13,J5:L8,J10:L13,N5:P8,and N10:P13,press [Delete] ,then click anywhere to deselect the ranges
See Figure 0-8.The hyphens in the subtotal and total rows and columns indicate that the current value of these cells is zero.The divide by zero error messages column S are only temporary and will disappear as soon as you open the template,save it as a workbook,and begin to enter next year's data.To make the template easier to use,it's best to have the first data entry cell selected when you save it.
4.Scroll left to bring columns B through G into view ,then click cell B5
5.Click File,click Save As ,click the Save as type list arrow,then click Template
Excel adds the xlt extension to the filename and automatically seitches to the Templates folder,as shown in Figure 0-19.If you are using a computer on a network,you may not have permission to save to the Templates folder.You'll save your template to the drive and folder where your Project Files are stored instead.
6.Click the Save in list arrow,click the drive and folder containing your Project Files ,click Save ,close the workbook,then exit Excel .
Next year,when Jim needs to compile the information for overtime hours,he can simply open a document based on the Overtime Hours template or apply the template to a new document and begin entering data.

英语翻译不要软件翻译的,原文为：Creating a TemplateA template is a workbook that contains text (such as column and row labels) ,formulas,macros,and formatting you use repeatedly.Once you save a workbook as a template,it provides a model
创建模板
模板是一个作业包含文本(如柱,连续标签) ,公式 宏和格式化你反复使用. 一旦你救习作为模板, 它提供了一个模式,创造新的习作您不必入标准数据. 志鸿提供了几个模版及Spreadsheet统计表解决了新的对话框. 在大多数情况下,虽然,你可能想要创建自己的模板,从工作,你经常使用. 当你保存一个文件作为模板,原来的作业维持不变. 吉姆计划使用相同的公式,职称冻结碎裂, 并连续标签栏,从超时工作,为以后年度的工作. 他会问你要删除额外的介绍,评论, 而这些数据每一个月,然后将该作业作为模板. 1.click sheet2的选项,按下CTRL键] ,点击sheet3标签,右击sheet3标签,单击删除, 然后点击删除. 2.righg点击压电细胞,然后点击删除评论说,现在你移走额外的介绍和评论, 您删除数据超时工作. 您离开公式整齐9,14和15 ,在电子栏目,我, m与Q , R ,和S号 然而,为了使另一个用户只需开始进入数据不需重新创造的公式. 3.press [ CTRL键] ,选择范围B5轿车: D8级,从B10 :和D13与F5 :Ⅷ, F10代: H13的J5型: 18 ,糖: L13号,农五: P8同, N10个:天文学,按下[删除] 然后点击任何地方里面的幅度见图0-8 . 横线的,在计及总排和栏目显示,目前的价值,这些细胞是零. 鸿沟零错误讯息栏收盘只是暂时会消失,只要你打开 模板,救它作为一个练习簿,并开始进入下一年度的数据. 为了使模板更加容易使用, 它的最大的一次数据输入单元选定时,你救它. 4.scroll左使B栏透过政眼帘,然后单击细胞B5轿车5.click档案 点击另存为,单击保存类型列表箭头, 然后单击模板志鸿祈福悸平延伸到文件,并自动seitches的模板文件夹中, 如图0-19 . 如果您使用的是计算机网络,你可能没有审批保存到模板文件夹. 您节省您的模板的驱动和文件夹如果你的项目档案存放. 6 . 单击保存名单箭头,点击驱动和文件夹,里面有你的项目文件,单击保存, 关闭簿,然后退出Excel的. 明年,当吉姆需要的资料汇编为超时工作, 他只需打开一个文件基于超时模板或用模板的新文件. 并开始进入数据.