Free Microsoft Office Tutorials | Online Office Learning Guide | Microsoft Office Tips and Tricks

• · To create a template
• Create the workbook that contains all layout and formatting elements you wish to save as a template.
• From the File menu, click Save As.
• Type the name for the template in the File name: text box.
• From the Save as type: drop down list box, select Template.

• Select Save. The extension .XLT is added to the file name and the template is saved in the Templates folder.

To use a template

• From the File menu, click New to display the New Workbook pane.
• From the Template section of the New Workbook pane, click on the blue On my computer… link display the Templates dialog box:

• Click on the General or the Spreadsheet Solutions tab to locate the template you want. For default template, click on the General tab and select the Workbook icon.

  Note: In the Spreadsheet Solutions tab, you can see 5 templates available. Most of the times you need to use the Microsoft Office CD in order to install the features and use it.

• Click OK to open a copy of the template.

Note: Excel 2003 allows you to access additional templates on the Microsoft Office website (required Internet connection). Just click on the Templates on Office Online link in the New Workbook pane, and you will be directed to the website and search for the template that you need.

Template vs Style

What is the different between Excel template and Excel style?

Style is a collection of cell formatting information such as font size, patterns, alignment, etc that you can define and save as a group.

If formatting information is assigned to cells using styles it is possible to easily update the appearance of a sheet by modifying the styles.

Excel comes with a number of styles pre-defined, by default all cells have the Normal style assigned to them. It is possible to copy styles from one Workbook to another.

To create a style

• Select a cell formatted with the attributes you required.
• From the Format menu, click Style.

• From the Style dialog box displayed, type the style name in the Style name: drop down list.
• Select the Modify button to change any of the attributes. The Format Cells dialog box will be displayed.
• Click on the Number, Alignment, Font, Border, Patterns and Protection tabs and make any changes required. Click OK to return to the Style dialog box.
• Click OK.

To apply a style

• Select the range of cells that you wish to format.
• From the Format menu, click Style.
• Select the style from the Style name: drop down list box.
• Select OK.

Bookmark it:

Popularity: 11% [?]

Word 2007 offers great tools for citing sources, creating a bibliography, and managing the sources. The first step to creating a reference list and citations in a document is to choose the appropriate style that you will be using for formatting the citations and references.

Style
To choose a publishing style:

• Click the References Tab on the Ribbon
• Click the drop down box next to Style in the Citations & Bibliography Group
• Choose the appropriate style.

Citations
To insert a citation in the text portion of your document:

• Click the References Tab on the Ribbon
• Click the Insert Citation Button on the Citations & Bibliography Group
• If this is a new source, click New Source
• If you have already created this source, it will in the drop down list and you can click on it

• If you are creating a New Source, choose the type of source (book, article, etc.)
• Complete the Create Source Form
• If you need additional fields, be sure to click the Show All Bibliography Fields check box
• Click OK

Placeholders
Placeholders can be utilized when there is a reference to be cited, but you do not have all of the information on the source. To insert a Placeholder:

• Click Insert Citation
• Click Add New Placeholder

Manage Sources
Once you have completed a document you may need to add or delete sources, modify existing sources, or complete the information for the placeholders. To Manage Sources:

• Click the References Tab on the Ribbon
• Click the Manage Sources Button on the Citations & Bibliography Group
• From this menu you can Add, Delete, and Edit Sources (note, you can preview the source in the bottom pane of the window

Bibliography
To add a Bibliography to the document:

• Place the cursor in the document where you want the bibliography
• Click the References Tab on the Ribbon
• Click the Bibliography Button on the Citations & Bibliography Group
• Choose Insert Built-in Bibliography/Works Cited or Insert Bibliography

Insert Footnote
Some types of academic writing utilize footnotes. To insert a footnote:

• Click the References Tab on the Ribbon
• Click Insert Footnote (or Insert Endnote depending on your needs)
• Begin typing the footnote

Bookmark it:

Popularity: 12% [?]