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.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2678) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Remove Some Stress at Tax Time! Doing your personal income taxes can be a royal pain. Why not make the process just a bit less stressful with our 101-question checklist. You can prepare for filing your taxes with confidence, knowing you've covered all your bases.

Check out Filing Your Income Taxes Checklist today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Applying a Style