Excel for Marketing Managers

Magic Squares

Magic
Squares

e. And last (finally!) click on the Protection tab; uncheck the box next to

the word Locked. Click on OK to exit.

3. Fill in the nine boxes with the digits 1 – 9.
   For now, it doesn’t really matter where they go.


4. Use AutoSum in D11.
   Click on cell D11. From the tool bar at the top of the page, click on the
   AutoSum icon symbol (∑). You should see cells D8:D10 highlighted, and a
   formula that says: =SUM(D8:D10)
   This is what you want, so press Enter.

Figure 134

Protecting cells from changes

Figure 135

Using AutoSum

to add values in

selected cells