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.
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.
- Left – Aligns the cell text to the left side of the cell.
- Center – Aligns the cell text to the center of the cell.
- Right – Aligns the cell text to the right of the cell.
- Fill – Repeat the cell text until the cell width is filled.
- 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.
- Top – Aligns the cell text to the top of cell.
- Middle – Aligns the cell text to the center of cell vertically.
- Bottom – Aligns the cell text to the bottom of the cell.
- 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.
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.
You can also select different orientation from the home tab under orientation
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.
You can also merge cells from the home tab under alignment menu, you can select merge and unmerge cells with text alignment.
You can also wrap text to shrink the text so that you can clearly see the complete text clearly within the cell.
You can also use wrap text option from home tab under alignment menu.
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.
Also you can set font from the home tab under the font group.
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.
You can also select border with different styles from home tab.
In this section you can set background color for cells to highlight particular cell.
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.