Microsoft Office Tutorials and References
In Depth Information
Session 3.1
Border styles applied to the worksheet
Figure 3-16
thick borders applied
double lines drawn
to separate totals
You can also specify a color for the cell borders by using the Color list box located on
the Border tab (see Figure 3-15). Joan does not need to change the border colors, but she
would like you to change the background color for the column title cells. When you copy
the formatting of a cell, any border that you have applied is also copied.
Applying Background Colors and Patterns
Patterns and color can be used to turn a plain worksheet full of numbers and labels into a
powerful presentation of information that captures your attention and adds visual empha-
sis to the different sections of the worksheet. If you have a color printer or a color projec-
tion device, you might want to take advantage of Excel’s color tools. By default, worksheet
cells are not filled with any color (the white you see in your worksheet is not a fill color
for the cells). To change the background color in a worksheet, you can use the Fill Color
button on the Formatting toolbar, or you can use the Format Cells dialog box, which also
provides patterns that you can apply to the background. When choosing to apply color to
a worksheet, you must always give consideration to the availability of a color printer. Also,
if you plan to print a worksheet as an overhead, black print on a clear overhead trans-
parency is easier to read than other colors.
Joan wants to change the background color of the worksheet. When she prints her report
later in the week, she will be using the company’s color laser printer. Therefore, she would
like you to explore using background color in the column titles for the two sales tables. She
suggests that you try formatting the column titles with a light-yellow background.
Search JabSto ::

Custom Search