Excel: Use Cell Styles to Change Formats

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Gurus of Microsoft Word have known about using styles for two decades. Microsoft promotes styles in Excel, adding a dropdown right on the Home tab offering 42 built-in styles.

  1. Excel offers 42 built-in cell styles on the Home tab.

    You can choose which styles you think are appropriate and which are not. Personally, I use Title and Heading 4 all the time. The other styles seem arbitrary. Why should calculated cells have an orange font? It makes no sense to me. In the figure below, cell A1 has a Title style. Row 3 and column A uses the Heading 4 style. Column F and Row 6 use the Calculation style.

  2. Some styles look good. Others do not.