How to Apply Cell Styles (Total, Input, Title…) in Excel
In this article, you will learn how to apply different cell styles in Excel.
Apply Cell Styles
Excel allows us to format cells with predefined cell styles. These include different font sizes and styles, backgrounds, border styles, colors, etc. We’ll use the following data range with sales data to explain applying cell styles.
Let’s first format the table headings (range B2:F2). To do this, (1) select the range, then in the Ribbon, (2) go to the Home tab and in the Styles part, (3) click on More.
In the offered menu, we can choose a cell style. In this case, we will use a style for headings and titles (Heading 2). As a result, the range of cells B2:F2 is formatted as shown in the picture below.
Next, we can format range B3:E9 as input cells. In order to achieve this, (1) select the range. Then in the Ribbon, (2) go to the Home tab and in the Styles part, (3) click on More. In the offered menu, we’ll choose a cell style. In this case, we will use a style for input data: (4) Input. As a result, the range of cells B3:E9 is formatted as shown in the picture below.
In the same way, we can format cells F3:F9 as calculation cells. Let’s (1) select the range, then in the Ribbon, (2) go to the Home tab and in the Styles part, (3) click on More. In the offered menu, we’ll choose a cell style. In this case, we will use a style for calculation data: (4) Calculation. As a result, the range of cells F3:F9 is formatted as shown in the picture below.
Finally, we’ll format cells B10:F10 as Total cells. (1) Select the range, then in the Ribbon, (2) go to the Home tab and in the Styles part, (3) click on More. In the offered menu, we’ll choose a cell style. In this case, we will use a style for totals and headings: (4) Total. As a result, the range of cells B10:F10 is formatted as shown in the picture below.
Modify Cell Styles
We can also modify any style that Excel offers by default. Let’s use the previous example and change the font color of the Total Amounts column (cells F3:F10) to blue. In order to achieve this, we need first to (1) select the range, then in the Ribbon, (2) go to the Home tab in the Styles part (3) right-click the current cell style (Calculation) and (4) click on Modify.
In the pop-up screen, (1) go to Format. Then in the new screen, (2) go to the Font tab, (3) click on the Color drop down and (4) choose Blue.
As a result, we get the style shown below, with Calculation fields having blue font.
In the same way as in the previous step, we could change number format, set bold or italic, change font size, etc.