This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Use Cell Styles to Change Formats
Gurus of Microsoft Word have known about using styles for a decade. In Excel 2010, Microsoft promotes styles in Excel, adding a drop-down right on the Home tab offering 42 built-in styles.
Figure 1171 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 H and Row 12 use the Calculation style.