Excel for Marketing Managers

Solving Systems of Equations

Solving
Systems of
Equations

point will narrow the width to accommodate the “x” in cell L8. Do the

same to column P.

d. Now you will change the widths of columns K, L, N, O, and Q using a

neat trick. Click on the K in column K to highlight the entire column.

Then, holding down the Ctrl key, click on the M and the Q. This will al-

low you to change the width of all three columns at the same time.

Move your cursor between the K and L until it changes to the plus sign

with the horizontal arrows. Then left click and you will see the current

column width as 8.43 (64 pixels). Hold down the left mouse button and

slowly move to the left until the width is 5.00 (40 pixels). Release the

mouse button and all three columns will change width. This width

should work for most problems. Once this is complete, if you ever get a

cell filled with ###, that tells you that the number in that cell is too big

for that width. Make adjustments at that time accordingly.

7. Do the formatting for the first equation.

a. Click on cell L8. While holding down the left mouse button, drag to the

right to cell P8. Press Ctrl+C to copy the contents of these five cells.

Click on cell L9. From the Edit menu on the toolbar, select Paste Spe-

cial, Values, and then click OK. The contents of the five cells, without

the color, have been copied. Now click on cell N9, and delete the B in

that cell.

Figure 261

Changing column width

Figure 262

Changing width of multiple non-contiguous columns