![]() To create the default workbook template, type Book. In the File name box, do one of the following: In the Save in box, select the folder where you want to store the template. Workbook calculation options and window view options. Macros, hyperlinks and ActiveX controls on forms. Text you want to repeat, such as page, column and row labels.ĭata, graphics, formulas, charts and other information. You can hide sheets, columns and rows to prevent changes to workbook cells. Protected and hidden areas of the workbook. The number and type of sheets in the workbook. Page formats and print area settings for each sheet. Settings that can be saved in a template: To use a workbook template, create a workbook that contains the sheets, default text (such as page headers and column/row headers), formulas, macros, styles and other formatting that you want to use every time you use the template. ![]() You can save workbook settings that you frequently use in a workbook template, and then automatically open that workbook template every time you start Excel. Navigate to the folder where the workbook was saved (either the XLSTART folder or an alternate folder location), select the workbook and press Delete.Īutomatically open a workbook template when you start Excel To stop a workbook from opening automatically when you start Excel do the following: Stop a specific workbook from opening when you start Excel If a workbook with the same name is in both the XLSTART folder and the alternate startup folder, the file in the XLSTART folder will open. ![]() ![]() Note: Because Excel will try and open every file in the alternate startup folder, make sure that you specify a folder that contains only files that Excel can open. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |