• Excel Book Excerpt

Excel Use Cell Styles to Change Formats

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.

25Fig01.jpg 

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.

25Fig02.jpg  

Figure 1172 Some styles look good. Others do not.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel: