Excel 2007: Templates and Styles
Using the Microsoft office Online Templates:
1. Click on the office button to open the drop down menu. 2. Click on New option. The Templates window will pop up.
There are 5 types of Templates options you can choose from: • • • • • Blank and Recent Can choose from Installed Templates My Templates New from existing…. Microsoft Online Templates
3. Once you have chosen the template that
you would like to use select it, then click on Download. Creating a template 1. Enter all of the necessary data. 2. Add or remove rows and columns as needed. 3. Create formulas, charts and other options. 4. Apply all formatting options. To save the template once all changes have been made to your spreadsheet:
1. Click on the office button to open the drop down menu. 2. Choose the Save As option. 3. Choose the Other formats option. 4. Choose the Save As option to open the Save As dialog box. 5. Click on the Save as type option to open the drop down list. 6. Scroll through the list to find the template options.
University of Houston-Downtown • Information Technology • Learning Technology Services
1
Excel 2007: Templates and Styles
Template options in Excel 2007 There are three templates that can be created in Excel 2007:
• • •
Excel Template (*.xltx) Excel Macro Enabled Template (*.xltm) Excel 97 - 2003 Template (*.xlt)
To apply the new style to cells in your spreadsheet 1. Select the desired cells. 2. Click the Home tab on the ribbon. 3. Click on the Cell Styles option on the ribbon to open the Cell Styles gallery. 4. Click on the new style name at the top of the gallery. 5. The style's formatting is immediately applied to the selected cells.
Create a Custom Formatting Style 1. Select a single spreadsheet cell. 2. Apply all desired formatting options to this cell. 3. Click the Home tab on the ribbon. 4. Click on the Cell Styles option on the ribbon to open the Cell Styles gallery. 5. Click on the New cell styles option at the bottom of the gallery to open the Style dialog box. 6. Type a name for the new style in the Style name box. 7. The formatting options already applied to the selected cell will be listed in the dialog box.
University of Houston-Downtown • Information Technology • Learning Technology Services
2