SECTION 3
Lesson 3.3 Enhancing a Worksheet’s Appearance

   

 

 

It is a simple task to add patterns and colours to a worksheet in Excel.

 

To add colours to a worksheet, select the range of cells you want to add colour to.

 

 

Click on the fill colour button on the formatting toolbar to display your colour choices and select a colour by clicking on it.

 

The range will now be shaded with the colour you selected.

 

 

The procedure to add patterns to a range is almost the same as for adding colour.

 

Fist, select a range of cells and choose Format -> Cells from the menu bar.

 

 

When the Format Cells dialogue box appears click the patterns tab, select a colour and choose a pattern from the drop down palette.

 

 

Click the OK button to apply the pattern to the selected range.