by Allen Wyatt
(last updated June 23, 2016)
Once you have defined styles, you can apply them throughout your worksheet as you deem appropriate. Styles can be applied by following these steps:
Figure 1. The Style dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2678) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
Standardize the formatting in your Excel workbooks quickly and easily with the Style feature. Here's how to use it.Discover More
Styles can make your worksheet formatting easier and more consistent. Here's how to copy styles from an existing workbook ...Discover More
Excel allows you to define styles that help you display data in a consistent manner. When you no longer need a particular ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.