Cell formatting in Microsoft Excel

Excel cells can be formatted according to work, data and user’s convenience.

To format cell go to cell which you want to format. Then right click on mouse then a small window will open where you can see many options. With those options you can format cell according your convenience.

Go to cell

Right click on your mouse

Small window will open

Click on format cell

cell formatting in microsoft excel
Cell formatting in Microsoft Excel

In the format cell window you will see the following tabs.

  1. Numbers
  2. Alignment
  3. Font
  4. Boarder
  5. Fill
  6. Protection

All tabs have different functions to format the cell.You can format the cell as per your requirement.

Numbers – The number tab have the following categories 

  1. General
  2. Number
  3. Currency
  4. Accounting
  5. Date
  6. Time
  7. Percentage
  8. Fraction
  9. Scientific
  10. Text
  11. Special
  12. Custom

With the above option you can format the cell according to your convenience. In the number tab, we can format the cell as follows

  1. Can increase and decrease decimal places in numbers
  2. You can add the currency symbol of any country before the money.
  3. Can change the date format
  4. Can change the Time format

And many more things you can do with Format cell option.

Alignment of cells

The alignment comes after the number tab. In the alignment tab, we align the text. Example, if we write the text inside the cell And if we want to make the text in the center, then we can do the text in the center in the alignment tab.

Cell Alignment in cells formatting
Cell Alignment

Text can be changed as per your wish by text alignment, text control, right-to-left, text orientation etc. in the Alignment tab.

In the alignment tab, we can change the orientation of the text.Suppose we want the orientation of the text to be 90 degrees, Then we will write 90 degrees in orientation,You will see that the orientation of the text has changed.

Cell Formatting


Fonts

The next tab is font. In the font tab, we can give any text a good look. We can underline it, change its color, shorten and enlarge the text.We can also make text style bold and italic.
 
Fonts in Cell Format
 
We can also see the preview of the text before changing it. We can give different effects to the text here. We can use many types of fonts to change the text here.


Border

In the border tab, we can give border to the cell.As shown in the picture, we can give many types of boarders to the cell. We can Change the color of border of cells.
border in cell format

 

Fill

In the Fill tab, we can change the background of the cell. We can fill any color of our choice in a cell.
Hope you have learned something with the help of this article. In future, this article will be updated from time to time.