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
Cell border – Change the cell border
Please refer to my future post on regarding to change of cell alignment and conditional formatting.