The Heading style illustrates how you can use a base font and then override specific settings, such as the size within the style. Once the styles are created, they are applied to cells one at a time. Later on, more efficient and complex means of setting the style across multiple cells will be illustrated. Finally, it is possible to create a format for a specific cell. This is inefficient if several cells will share the same format, as the resulting spreadsheet will contain new formatting information for each cell, bloating the size of the resulting spreadsheet.
Styles are the best way to ensure that a group of cells have the same look.
When you apply a single style object to several cells, the style information is written to the spreadsheet only once, conserving space. Create a format for a specific cell only when there is little chance that the format will be used in multiple cells. In this example, only the final result is displayed in red and a different font so it makes sense to create a format for this cell alone. If Section Summary Style , Format and Font objects create the look for one or more cells. Use Formats to override Styles in a more specific context.