Applying and Creating Cell Styles

A cell style is a defined collection of formats—font, font size, attributes, numeric formats, and so on—that you can store as a set and later apply to other cells. For example if you always want subtotals to display in blue 14-point Times New Roman, bold, italic, with two decimal places and commas, you can create a style that includes all these formats. A cell style can help you quickly create a consistent look for your workbook. If you plan to enter repetitive information, such as a list of dollar amounts in a row or column, it’s often easier to apply the desired style to the range before you enter the data. That way you can simply enter each number, and Excel formats it as soon as you press Enter. You can use ...

Get Excel® 2013 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.