Formatting Cells In Excel

Cells are the basic block of Excel worksheet structure, in this tutorial you will learn different options available for formatting cells in Excel.

Formatting Cells In Excel

Setting Cell Type

First option available in formatting cells is to select cell type. You can add different type of data like numbers, dates, currency, fraction, text etc. To select a cell type select a cell, right click on the cell and select the format cells option. A dialogue box will open containing different tabs. First tab contains different cell formats you can choose for the cells.  You can select a format according to your requirement.  To know about these cell formats read this post Various Cell Formats In Microsoft Excel.

 

Set cell type in formatting cells In Excel

 

Text Alignment

In the alignment tab you will find different alignment options for the cells, lets know about these features.
Text Alignment In Formatting Cells

 

There are two types of alignments available horizontal and vertical alignment.

  • Horizontal Alignment – In horizontal alignment you can set text alignment to left, center, right etc.

 

Horizontal Alignment In Formatting Cells

 

  1. Left – Aligns the cell text to the left side of the cell.
  1. Center – Aligns the cell text to the center of the cell.
  1. Right – Aligns the cell text to the right of the cell.
  1. Fill – Repeat the cell text until the cell width is filled.
  1. Justify – This option will justify the text to the right or left side of cell and this option only works if you have used wrapped text option for the cell.
  • Vertical Alignment – In vertical alignment you can set text alignment to the top, center and bottom of the cell.

 

Vertical Alignment In Formatting Cells

 

  1. Top – Aligns the cell text to the top of cell.
  1. Middle – Aligns the cell text to the center of cell vertically.
  1. Bottom – Aligns the cell text to the bottom of the cell.
  1. Justify – This option will justify the text vertically in the cell, again this option will only work if you have selected wrapped text option.

You can also use alignment options from the Home tab under alignment group.

 

alignment Setting In Home Tab -Formatting Cells

 

Cell Text Rotation

In this option you can set the degree of rotation for the cell text, you can either fill the degree in the box or you can slide the arrow with the mouse button to select the degree of rotation.

 

Ce

 

You can also select different orientation from the home tab under orientation

 

Cell Text Rotation From Home Tab - Formatting Cells

 

Merge Cells

With this option you can merge two or more cells. You can select the merge cell option in the alignment tab in format cell dialogue box. It will merge cells and align the text according to the selected alignment.

 

Merge Cells - Formatting Cells

 

You can also merge cells from the home tab under alignment menu, you can select merge and unmerge cells with text alignment.

 

Merge Cells From Home Tab - Formatting Cells

Wrap Text

You can also wrap text to shrink the text so that you can clearly see the complete text clearly within the cell.

 

Wrap Text - Formatting Cells

 

You can also use wrap text option from home tab under alignment menu.

 

Wrap text Home Tab - Formatting Cells

 

Setting Font

The third tab contains the different options for setting font. You can also use the short cut ctrl + 1 or shift + ctrl + F to open the setting font tab directly. You can select different type of font (Calibri is default font selected), font style (You can choose regular, bold, italic or both bold italic font style), font size (by default 11 is the selected font size), underline the font (single or double), color of the font and effects for the text. (Three effects are available strike through, super script, sub script. Choose different effect style to know better.) When you select any of above options you can view the changes in the preview section.

 

Set Fonts -Formatting Cells

 

Also you can set font from the home tab under the font group.

 

Setting Font Home Tab - Formatting Cells

 

Border

In this section you can apply border to the selected cells, you can select the boarder style and border color before applying the order to the selected cells.

 

Borders -Formatting Cells

 

You can also select border with different styles from home tab.

 

Select Border Home Tab - Formatting Cells

 

Fill

In this section you can set background color for cells to highlight particular cell.

 

Fill Color - Formatting Cells

 

I hope now you are clear about options available for formatting cells, if you have any query, you can leave a comment. You will get the answer as soon as possible. Stay tuned with Scoolico.