Microsoft Office Tutorials and References
In Depth Information
Working with Colors and Backgrounds
Formatting Cell Content
• To change the font, select the cell or range. In the Font group on the Home tab, click
the Font arrow, and then click a font.
• To change the font size, select the cell or range. In the Font group on the Home tab,
click the Font Size arrow, and then click a font size.
• To change a font style, select the cell or range. In the Font group on the Home tab,
click the Bold, Italic, or Underline button.
• To change a font color, select the cell or range. In the Font group on the Home tab,
click the Font Color button arrow, and then click a color.
• To format a text selection, double-click the cell to enter Edit mode, select the text to
format, change the font, size, style, or color, and then press the Enter key.
Working with Colors and Backgrounds
Another way to distinguish sections of a worksheet is by formatting the cell background.
You can fi ll the cell background with color or an image. Tom wants you to format the
Documentation worksheet by adding fi ll colors and background images.
Changing a Fill Color
By default, Excel does not add any background color to worksheet cells; but background
colors, also known as fi ll colors, can be added using the same color palette you use for
font colors. The labels in the Documentation worksheet should be in a white font on a
blue background. The author’s name, current date, and purpose of the worksheet should
be in a blue font on a white background. You will make both of these changes to the
Documentation worksheet.
You can add a fill color to
a sheet tab. In the Cells
group on the Home tab,
click the Format button,
point to Tab Color, and
then click a color.
To change the background fill color:
1. Select the range A4:A6 .
2. In the Font group on the Home tab, click the Fill Color button arrow
, and
then click the Blue color (the eighth color) in the Standard Colors section.
3. In the Font group, click the Font Color button arrow
, and then click the
White color in the Theme Colors section.
4. Select the range B4:B6 , and then format the cells with a blue font on a white
background.
5. Increase the width of column B to characters. 55
6. Click cell . See Figure 2-5. A7
 
Search JabSto ::




Custom Search