1, custom template
Enter the folder c: documents and settings user name templates, right-click the blank space and select? New? Microsoft Excel worksheet? Create a new Excel file and name it excel9.xls, double-click the excel9.xls file, and then make some personalized settings for the font.
What about the future? Resource manager? Right-click the mouse and select? New? Microsoft Excel worksheet? , and then double-click the new document, you will find that it has applied the settings in excel9.xls, so that you can use your own personalized excel spreadsheet.
2. Change the default worksheet by yourself
Generally speaking, choose? Insert? Worksheet? , a new worksheet will be inserted in the current workbook using the default worksheet template. However, you can modify this default workSheet: first create a workbook with only one worksheet, save it as a template named sheet, and then copy it to the folder C: program files Microsoft Office10xlstart. In the future, when a new file is created in Excel, it will be used as a template for inserting a new worksheet.
3. Get more template resources.
If you think that the templates built into Excel can't meet your needs, you can download more templates from the Internet: Start Excel and choose? Documents? New? , again? New workbook? Task pane, and then click? Microsoft.com's template? Link, so that you can open the Chinese template library of Microsoft website. Many categories of templates are provided. As long as you click on the template type link on the webpage, you can see the name and provider of this kind of template on the webpage. Click the template name, and in the? End user license agreement template? Click in the window? Do you agree Button and click? Edit in Microsoft Excel? IE will download the template and open it automatically with Excel XP. If you are satisfied with the template effect, use it again? Save as? Save as a template, which can be called like a normal template.
In addition, there are many Excel templates available for download online.
For Windows users in the local area network, custom templates can be shared by other users on the network. Put the custom template into the * * * folder and create a shortcut for the * * * folder. Other users on the network can put this shortcut in their own C: Program Files Microsoft Office Templates 2052 folder, and then they can call it like a locally installed template.
4. Make the default workbook more personalized.
Many users report that they cannot modify the default workbook and worksheet templates. In fact, this is because they don't know how to modify it. Run Excel and select all worksheets Sheet 1. Format? Or? Okay？ Under the menu? Line height? Modify the row height. Select all sheets1again, and then click? Format? In the toolbar? Format brush? . Click the worksheet tab to switch to Sheet2 and use? Format brush? Click the upper left corner of Sheet2 (i.e.? 1? And then what? Answer? Junction), what is the format of Sheet 1? Cloning? Go to worksheet 2. By repeating the above operations, you can modify the format of the whole workbook, then save the template named book, and then go to the folder C: program files Microsoft Office10xl to delete the template file named Book (if any). Finally, copy the modified Book template to the XLStart folder, and Excel will use the template to create a new default workbook when it is restarted.
Through the above steps, we can clearly understand and learn the skills and methods of using templates in excel. As long as you master the use of excel templates, you can easily use excel.