Tips, Tricks, and Answers

The following articles are available for the 'Styles' topic. Click the article''s title (shown in bold) to see the associated article.

   Applying a Style
Styles can be a great help in making sure that the cells in a worksheet are formatted consistently. Here's how to apply the styles you've previously defined.

   Changing an Existing Style
Excel allows you to create styles that define how your data looks. At some point you may want to change a style you previously created. Here's how to do it.

   Copying Styles
Styles can make your worksheet formatting easier and more consistent. Here's how to copy styles from an existing workbook to another one.

   Creating Styles
Standardize the formatting in your Excel workbooks quickly and easily with the Style feature. Here's how to use it.

   Deleting a Style
Excel allows you to define styles that help you display data in a consistent manner. When you no longer need a particular style, follow this tip to delete it.

   Deleting Unwanted Styles
Custom styles can be a great help in formatting a worksheet. You may, at some point, want to get rid of all the custom styles within a given workbook. Here's a quick macro that can make that task easy.

This Site

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.

Newest Tips

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.