|Connect us with


Cell Formatting in Excel

Cell Formatting Using this we can make a lot of changes to the selected cells, you can align cell data to center, left, or right. And also we can convert cell value to Number, currency, Percentage,& date format also.we can also Align the cell value, and we can fill color, border and more.

How to use Cell Formatting in Excel?

in this chapter, we are going to discuss some of the basics of excel formatting.

1. To Bold selected cell value click B or use short cut CTRL+B.
2. To do selected cell Italic click on I or use short cut CTRL+I.
3. To do selected cell Underline click on U or use shortcut CTRL+U.

Cell Formatting in Excel

4. To add borders to the selected cell click on Borders from Font Group and selected what kind of border you want from there.

Cell Formatting in Excel

4. To add borders to the selected cell click on Borders from Font Group and selected what kind of border you want from there.

5. To add Backgroud color to the selected cell click on "Fill Colour" and chose which color you want to add. In the same to add font color click on "Font Colour" and chose which color you want to add.
6. To Align Texts use Align To Left, Centre Text, and Align to Right options.

Cell Formatting in Excel

in this way, we can do text formatting in excel. After watching the video you can download below sample sheet. and it helps you to do practice more. please subscribe for more videos in our youtube channel. if you like our tutorial please share it on Facebook & Youtube below.


To Get FREE Excel Shortcut Keys
       



Previous

Next



YOUR COMMENTS ARE MOST IMPORTANT TO US:

0 Comments



Why basictutorials.in ?

● To Learn Tutorials in a Simple Way.

● To Learn Excel Basics With Downloadable Samples.

● To Learn HTML With Sample Website Code.

● To Learn PowerPoint Presentations.

● To Learn MS Word for Offical use.