Excel for Marketing Managers

Candy Bar Fractions

Candy Bar

Fractions

3. Format range B12:G13.
   Move your cursor to cell B12. Left-click and drag to the right and down to
   highlight the range B12:G13 and let go of the mouse button. Press Ctrl+1 to
   access the Format Cells dialog box. You will make three changes:

a. Click on the Font tab. Change Font to Arial and Size to 72.

b. Click on the Border tab. Click on the Inside Preset at the top of the

page. Next, under Line Style, click on the thickest line in the right col-

umn. Then, click the down arrow in the Color box, and select Brown

from the top row of the palette. Now click Outline in the Presets.

Figure

170

Setting

the

height of

rows 12

and 13 to

90 pixels