MrExcel.com - Your One Stop for Excel Tips & Solutions

Use Cell Styles to Change Formats

September 13, 2023 - by

Use Cell Styles to Change Formats

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.

The Cells Styles gallery offers many built-in styles.
Figure 1320. 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.

This shows the use of cell styles. Title is used in A1 and is a larger font. Heading4 is used for labels in A and headings in 3. The Total row and columns format the calculated totals as Calculation.
Figure 1321. Some styles look good. Others do not.

This article is an excerpt from Power Excel With MrExcel

Title photo by Alexander Grey on Unsplash