MS Excel - Lesson 7: Sample Excel file - How to create and use
When working with spreadsheets, sometimes you want to use the same layout or design. You can re-create the design every time to use it or you can create a template yourself.
You can create templates for workbooks and worksheets. The default form for workbooks is Book.xlt . The default form for the worksheet is Sheet.xlt
Create templates with the following sections:
- Text and graphics
- Layout and format types
- Headers and Footers
- The formulars
- Macro
Create a template
- Create a workbook of all layouts and format the elements you want to save as a template
- From the File menu, click Save As .
- Name the template in the File name section
- From Save as type: click on the drop down arrow list, select Template .
- Select Save . Extension extension .XLT is added to the file name and template saved in the Templates folder
Use the template
- From the File menu, click New to display the New Workbook section
- From New Workbook , click on the On my computer link . to display the Template dialog box
- Select the General or Spreadsheet Solutions tab to locate the template you want. With the default template, select the General tab and select the Workbook icon
Note : In the Spreadsheet Solutions tab, you can see 5 templates available. You can use Microsoft Office discs to install features and use them.
- Click OK to open a template
Note : Excel 2003 allows you to access additional templates on the Microsoft Office website. Just click on the Templates on Office Online link in the New Workbook pane, so you can search for the templates you need.
What is the difference between Excel template and Excel style?
Style is a collection of cell information formats such as font size (font size), patterns (styles), alignment (alignment), . you can define and save as a group
If formatting information using style, it can easily update sheet form by changing styles.
Excel has a number of unspecified styles, all cells have Normal type. It can copy styles from one Workbook to another.
Create a style
- Select a format box with attributes
- From the Format menu, click Style .
- Style dialog box appears, type the type name into Style name or click on the drop-down arrow and select
- Select Modify button to change properties. The Format Cells dialog box is displayed
- Click the Number , Alignment , Font , Border , Patterns , Protection tabs and make changes. Click OK to return to the Style dialog box
- Click OK
Apply a style
- Select the area you want to format
- From the Format menu, click Style .
- Select style from Style name
- Click OK .
You should read it
- 7 free Excel templates to help manage the budget
- Summary of expensive shortcuts in Microsoft Excel
- 5 useful Microsoft Excel formulas for calculating taxes
- Link download Microsoft Excel 2019
- MS Excel 2007 - Lesson 3: Working with Workbook
- How to Make Payroll on Excel in the US
- How to make a thermometer template in Excel
- Complete guide to Excel 2016 (Part 1): Get familiar with Microsoft Excel
May be interested
- MS Excel - Lesson 9: Protect spreadsheets and Excel filesexcel spreadsheet and file protection features allow document protection and only authorized people can open it.
- How to fix Vietnamese error when opening CSV file in Excelwhen converting excel file data into a csv file, you often encounter errors that do not display vietnamese fonts. this will undoubtedly have a small impact on your work. so how to fix the excel file error when converting to csv.
- Create Hyperlink in Excelcreate hyperlinks in excel - the following article guides you to create hyperlinks to websites, to other sheets in the same excel file, links to newly created excel files and links to email addresses.
- How to insert a Word document into an Excel fileto be able to open word text files right in excel file, we can use the built-in feature to allow inserting data right on excel.
- How to set Excel password to secure data filesetting up excel password has many ways, from simple to use excel's built-in password feature to use vba. below tipsmake.com will show you the most basic ways to protect your excel file.
- Instructions for inserting a PDF file into Excel spreadsheetif you're having trouble inserting a pdf file into an excel spreadsheet and you don't know how to do it. inserting pdf files into excel spreadsheets is not as simple as you think. in the article below, network administrator will guide you through the steps to insert a pdf file into excel spreadsheet.
- How to create Hyperlink to link spreadsheets in Excelwhen creating hyperlink on excel, we can link data tables together or access a new spreadsheet file quickly.
- Microsoft Excel test P5in the article below, network administrator will send you more useful information about excel software through the following quiz. let's see how much you know about excel.
- How to create hyperlinks in excel is extremely usefulcreate hyperlink in excel. this hyperlink button is extremely convenient, can create links to other sheets, emails, websites, or a newly created excel file.
- MS Excel 2003 - Lesson 3: Manipulating data in spreadsheetsthe previous article tipsmake.com has guided you to some basic formatting for a small data area, but if you need to format a large area or the default format for a new excel 2003 file, follow these instructions.