
Tips.Net > ExcelTips Home > Formatting > Styles > Creating Styles
Summary: Standardize the formatting in your Excel workbooks quickly and easily with the Style feature. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)
Excel provides a powerful feature that allows you to standardize your formatting easily and quickly. These are called styles, which are nothing more than patterns for how you want cells to look. These patterns are saved, using names you define, and can then be reused as you need them.
The quickest way to create a style is to first format a cell manually. It should possess the formatting attributes you want contained in the style. Make all the changes to the font, number format, alignment, color, patterns, and borders that you want. When it appears as you want it to, follow these steps:
You can also define a style that is not based on the current cell, even though Excel always assumes you will use the current cell. This is done by entering the style name in the Style dialog box and then clicking on the Modify button. You will then see the Format Cells dialog box where you can make changes for the style you are defining.
Tip #2677 applies to Microsoft Excel versions: 97 2000 2002 2003
Save Time and Money! Many people need to keep track of employee time, but don't know where to start when it comes to creating a spreadsheet. Here's a way to save time, effort, and money with ready-to-use timesheet templates.
Check out Timesheet Templates today!
If you have tons of data to analyze, one of the best tools in Excel's arsenal is the PivotTable. Learn how to use this tool to analyze your data. (more information...)
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site