How to do change font style in Excel One of the most common Excel interview question.
How to change cell formatting in excel – Excel Interview question
This blog will illustrate how to change cell formatting in excel.
From my previous post, I have already mentioned:
- How to change data format in Excel
- How many data format/data type available in Excel
Now, let’s talk about how to change the “Look” of a cell in excel.
When we say changing the “look” of a cell in excel, we can actually change :
- The font style or color
- The Border style
- Cell Background
- Cell Alignment
We can also instruct excel to present the cell in different format under different conditions – conditional formatting.
How to change the font style or font color?
To change the font style, you can use buttons in the Font’s group from the Home Ribbon
Following is an explanation to each buttons
Bold Button – Bold or “unbold” the the cell (Short key Ctrl + B)
Italic Button – Present the cell in Italic Format (Short Key Ctrl + I)
Underline Button – Underline the values in the current cell (Short Key Ctrl + U)
Font Color – Change the font color of a cell
Fill Color – Change the background color of a cell
Cell border – Change the cell border
Font Face Selection – Select he font face of a cell
Please refer to my future post on regarding to change of cell alignment and conditional formatting.