| Be My Friend

Cell Formatting in Excel

Font Formatting | Cell Alignment | Numbers | Percentage | Fill Colour

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.

Formatting a Cell in Excel

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.

Excel Bold Format

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.

Excel Italic Format

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.

Excel Format Cells

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.

Excel Format Cells Dialog Box

Cell Alignment

To do an alignment on Excel cells, click on the orientation option.

Orientation in Excel

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.

Excel Cell Rotation

Numbers

To get the Number option, open the format cells dialog box. there you will get the Number in the Category.

Number in Cell Formatting

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.

Percentage Format

To apply the percentage format, go to Home Tab, in the Number group, click on the Percentage symbol.

Percentage Formatting

Fill Colour

To fill background colour to the cell, go to the Home tab, in the Font group, click on the fill color.

Fill Background Colour

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.


To Get FREE Excel Shortcut Keys
       



Previous

Next

Why basictutorials.in?

To Learn:

Tutorials in a simple Way.

Excel with downloadable samples.

HTML with sample website code.

PowerPoint presentations.

MS Word for offical use.

Useful Tutorials