Tips.Net > ExcelTips Home > Formatting > Styles > Applying a Style
Applying a Style
Summary: How to apply a style to an Excel worksheet. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)
Once you have defined styles, you can apply them throughout your worksheet as you deem appropriate. Styles can be applied by following these steps:
- Select the cell or range of cells you want to format with the style.
- Choose Style from the Format menu. You will see the Style dialog box. (Click here to see a related figure.)
- Use the Style Name pull-down list to select the style you want applied to the cells you selected in step 1.
- Click on the OK button. The attributes for that style are applied to the selected cells.
Tip #2678 applies to Microsoft Excel versions: 97 2000 2002 2003
Step Up and Take Control! Subscribers to ExcelTips know just how valuable a resource it is. ExcelTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on ExcelTips archives and e-books.
Check out ExcelTips Premium today!
An Amazing Resource!
Thousands of ExcelTips, available for immediate download. Have all the Microsoft Excel info you need, right at your fingertips. (more information...)
Helpful Links
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