Excel for Marketing Managers

Candy Bar Fractions

Candy Bar
Fractions

12. Hide the text in H13 and H14.
    Remember back in Step 6, when you left some work to come back to at a
    later time? Now is the time! Click on cell H12 and drag down to highlight
    cells H13 and H14. Press Ctrl+1. Click on the Font tab. Under Color, click
    on the down arrow next to the word “Automatic” to view the color palette.
    Click on the white color in the lower right hand corner. Click OK to exit.


13. Format the cells and enter the text for the first set of objectives.
    Move your cursor to cell B1. Click and drag to the right to cell G1. Press
    Ctrl+1 for Format Cells and click on the Alignment tab. Change Horizontal
    alignment to Center and put a check mark next to Merge cells. Click on the
    Font tab; change Font to Arial and Size to 18. Click OK to exit. Inside the
    cell, type the following text: Divide the candy bar into fractional parts.
    Press Enter.

Note:

Notice that when you click on one of these cells you can see the formula in the

Formula bar, but you cannot see the text in the cells.

Figure 178

Using a white font color

to hide text