Using cell formatting in Excel, you can make a lot of changes to the excel cells, like cell alignment, font family changes, font color, cell border, etc., and also you can convert cell value to a number, currency, percentage, date format, etc.
1. To bold the selected cell value click on B or use shortcut CTRL + B. To remove bold formatting again click on B or use shortcut CTRL + B.
2. If you want to add italic to the cell click on the I or use shortcut CTRL + I. To remove Italic formatting again click on the I or use shortcut CTRL + I.
3. In the same way, you can also use the shortcut CTRL + U to add underline to the cell.
There is one more method is there to add font formatting to the cell. that is right click on the cell there you will get Format Cells options.
Click on the Format cells option, you will get one more dialog box with Format Cells heading. using this dialog box you can do a lot of formatting to the selected cell.
To do an alignment on Excel cells, click on the orientation option.
If you want to rotate clockwise, Anticlockwise, Vertical, Text up, Text Down to the excel cell, just select the available option from the drop-down.
To get the Number option, open the format cells dialog box. there you will get the Number in the Category.
With this Number Tab, you can select how many decimals you want for numbers. by default, it comes with two decimals. if you want to increase or decrease you can change the decimal places.
To apply the percentage format, go to Home Tab, in the Number group, click on the Percentage symbol.
To fill background colour to the cell, go to the Home tab, in the Font group, click on the fill color.
After watching the video you can download below sample sheet. and it helps you to do practice more. please subscribe for more videos on our youtube channel. if you like our tutorial please share it on Facebook and Youtube below.