Excel® 2013 On Demand

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 ...