See all How-To Articles

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 final 2

 

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.

 

apply cell styles input data 2

 

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.

 

apply cell styles 2

 

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.

 

apply heading style 2

 

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.

 

apply input style 2

 

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.

 

apply calculation style 2

 

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.

 

apply total style 2

 

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.

 

modify cell styles 2

 

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.

 

modify cell styles font color 2

 

As a result, we get the style shown below, with Calculation fields having blue font.

 

apply cell styles final 2

 

In the same way as in the previous step, we could change number format, set bold or italic, change font size, etc.