Adding Color and Patterns to Cells

Adding Color and Patterns to Cells

graphics/microsoft24.gif

You can fill the background of a cell with a color and a pattern to make its data stand out. Fill colors and patterns can also lend consistency to related information on a worksheet. On a sales worksheet, for example, formatting all fourth-quarter sales figures with a blue background and all second-quarter sales with a yellow background would make each group of figures easy to identify. You can use fill colors and patterns in conjunction with text attributes, fonts, and font colors to further enhance the appearance of your worksheet.

Apply Color and Patterns

graphics/one_icon.jpg

Select a cell or range to which you want to apply colors and patterns.

graphics/tow_icon.jpg

Click the Format menu, and then click Cells.

graphics/three_icon.jpg

Click the Patterns tab.

graphics/foure_icon.jpg

To add shading to the cell, click a color in the palette.

graphics/five_icon.jpg

To add a pattern to the cell, click the Pattern list arrow, and then click a pattern and color in the palette.

graphics/six_icon.jpg

Click OK.

graphics/05inf14.jpg

Did You Know?

You can paint a format . When you paint a format using the Format Painter button on the Standard toolbar, the fill colors and patterns get copied too.

Apply Color Using the Formatting Toolbar

graphics/one_icon.jpg

Select a cell or range.

graphics/tow_icon.jpg Click the Fill Color button list arrow on the Formatting toolbar.

If necessary, click the Toolbar Options list arrow to display the button.

graphics/three_icon.jpg

Click a color.

graphics/05inf15.jpg

Did You Know?

You can use the Print Preview button on the Standard toolbar to save time . Preview your worksheet before you print it, especially if you don't have a color printer. Some colors and patterns look great on screen but can make a worksheet difficult to read when printed in black and white.



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net