Post By: Hanan Mannan
Contact Number: Pak (+92)-321-59-95-634
-------------------------------------------------------
MS Excel - Text Alignments
Contact Number: Pak (+92)-321-59-95-634
-------------------------------------------------------
MS Excel - Setting Colors
You can change the background color of the cell or text color.
Changing Background Color
By default the background color of the cell is white in MS Excel. You can change it as per your need from Home tab » Font group » Background color
Changing Foreground Color
By default the foreground or text color is black in MS Excel. You can change it as per your need fromHome tab » Font group » Foreground color
Also you can change foreground color by select cell Right click » Format cells » Font Tab » Color
MS Excel - Text Alignments
If you don’t like the default alignment of cell, you can make changes in the alignment of cell.Below are various ways of doing it.
Change Alignment from Home Tab
You can change Horizontal and vertical alignment of the cell. By default, Excel aligns numbers to the right and text to the left. Click on the available option in the Alignment group in Home tab to change alignment.
Change Alignment from Format cells
Right click on cell and choose format cell. In format cells dialogue choose Alignment Tab.Select the available options from the Vertical alignment and HOrizontal alignment options
Exploring Alignment Options
1. Horizontal Alignment: You can set horizontal alignment to Left, Centre, Right, etc
-
Left: Aligns the cell contents to the left side of the cell.
-
Center: Centers the cell contents in the cell.
-
Right:Aligns the cell contents to the right side of the cell.
-
Fill:Repeats the contents of the cell until the cell’s width is filled.
-
Justify:Justifies the text to the left and right of the cell. This option is applicable only if the cell is formatted as wrapped text and uses more than one line
2. Vertical Alignment: You can set Vertical alignment to top, Middle, bottom, etc
-
Top:Aligns the cell contents to the top of the cell.
-
Center: Centers the cell contents vertically in the cell.
-
Bottom: Aligns the cell contents to the bottom of the cell.
-
Justify:Justifies the text vertically in the cell; this option is applicable only if the cell is formatted as wrapped text and uses more than one line
Left: Aligns the cell contents to the left side of the cell.
Center: Centers the cell contents in the cell.
Right:Aligns the cell contents to the right side of the cell.
Fill:Repeats the contents of the cell until the cell’s width is filled.
Justify:Justifies the text to the left and right of the cell. This option is applicable only if the cell is formatted as wrapped text and uses more than one line
Top:Aligns the cell contents to the top of the cell.
Center: Centers the cell contents vertically in the cell.
Bottom: Aligns the cell contents to the bottom of the cell.
Justify:Justifies the text vertically in the cell; this option is applicable only if the cell is formatted as wrapped text and uses more than one line
0 comments:
Post a Comment