Excel for Marketing Managers

Math Art

Math Art

a. Move your cursor to the extreme left edge of the worksheet to the box

that has the 1 in it for Row 1. Your cursor will change to a right-

pointing arrow. Move it down towards row 2 and it will change into a

plus sign with vertical arrows. Left-click, and you will see how high

your rows currently are. It should say “Height: 12.75 (17 pixels)”. If it is

different, that’s OK; just remember the pixel size.

b. Now move your cursor to the A in the rectangle above cell A1 and it will

change into a down-pointing arrow. Left-click and slowly drag to the

right. Notice that as you drag, Excel counts the number of columns (1C,

2C, 3C, etc.). When you reach the 25th column, which is column Y, stop.

c. Now move your cursor to the line between column X and column Y until

your cursor turns into a plus sign with horizontal arrows. Left-click and

drag to the left until the pixel size is 17 (or whatever you discovered

your row height to be). Press the Home key on your keyboard to return

to cell A1. You now have 25 columns that are the same size as your row

height.

2. Draw a border around the grid.

a. From the View drop down menu, select Toolbars and click on Borders. A

small toolbar will appear somewhere on your worksheet. On the left

Figure 161

Making columns the same width as the

row height

Figure 160

Excel counts the columns as you drag