Formatting Texts in Microsoft Excel: Excel MOOC
Microsoft Excel Massive Open Online Course
http://excelmooc.com/course/watch-For...
Align Text Within a Cell.
You can make your worksheets easier to read by aligning text and numbers within each cell. By default, Excel aligns numbers with the right side of the cell, and it aligns text with the left side of the cell. You can also align your data vertically within each cell. By default, Excel aligns all data with the bottom of each cell, but you can also align text with the top or middle.
Align Text Horizontally.
Select the range you want to format.
Click the Home tab.
In the Alignment group, click the horizontal alignment option you want to use:
Click Align Text Left to align data with the left side of each cell.
Click Center to align data with the center of each cell.
Click Align Text Right to align data with the right side of each cell.
Excel aligns the data horizontally within each selected cell.
Align Text Vertically.
Select the range you want to format.
Click the Home tab.
In the Alignment group, click the vertical alignment option you want to use:
Click Align Text Top to align data with the top of each cell.
Click Align Text Middle to align data with the middle of each cell.
Click Align Text Bottom to align data with the bottom of each cell.
Excel aligns the data vertically within each selected cell.
Center Text Across Multiple Columns.
You can make a worksheet more visually appealing and easier to read by centering text across multiple columns. This feature is most useful when you have text in a cell that you use as a label or title for a range. By centering the text across the range, it makes it easier to see that the label or title applies to the entire range.
Select a range that consists of the text you want to work with and the cells across which you want to center the text.
Click the Format tab.
Click Cells.
Excel opens the Format Cells dialog box.
Click the Alignment tab.
Click the Horizontal and then click Center Across Selection.
Click OK.
Excel centers the text across the selected cells.
Rotate Text Within a Cell.
You can add visual interest to your text by slanting the text upward or downward in the cell. You can also use this technique to make a long column heading take up less horizontal space on the worksheet.
Excel offers several predefined rotations, such as Angle Counterclockwise, which angles text upward at a 45-degree angle; or Rotate Text Up, which displays the text vertically with the letters running from the bottom of the cell to the top. You can also make cell text angle upward or downward by specifying the degrees of rotation.
Select the range containing the text you want to angle.
Click the Format tab.
Click Cells.
Excel opens the Format Cells dialog box.
Click the Alignment tab.
Click an orientation marker.
You can also use the Degrees spin box to type or click a degree of rotation.
You can click the vertical text area to display your text vertically instead of horizontally in the cell.
Click OK.
Excel rotates the cell text.
Add a Background Color to a Range.
You can make a range stand out from the rest of the worksheet by applying a background color to the range. For example, many people apply a background color to the labels in a range, which makes it easier to differentiate the labels from the data. Perhaps the easiest way to change the background color is by applying a color from the set of 60 predefined colors that come with the workbook’s theme. You can also choose a color from Excel’s palette of standard colors, or from a custom color that you create yourself.
Select a Theme or Standard Color.
Select the range you want to format.
Click the Home tab.
Click in the Fill Color list.
Click a theme color.
Alternatively, click one of Excel’s standard colors.
Excel applies the color to the range text.
To remove the background color from the range, click No Fill.
Select a Custom Color.
Select the range you want to format.
Click the Home tab.
Click in the Fill Color list.
Click More Colors.
The Colors dialog box appears.
Click the color you want to use.
You can also click the Custom tab and then either click the color you want or enter the values for the Red, Green, and Blue components of the color.
Click OK.
Excel applies the color to the selected range.