Excel for Marketing Managers

Multiplication Tables

Multiplication
Tables

3. Press F4 twice to lock just the row.


4. Type the Asterisk key on the numeric keypad.


5. Type the Left-arrow to move to A2.


6. Type the F4 key three times to lock just the column number.

More Cool Fill Handle Tricks

At the start of this chapter, you used the fill handle to extend a series starting

with 1, 2. The fill handle can automatically enter many types of data in a range

of cells.

1. Type “Sep” into a cell. Select the cell. Click on the fill handle and drag down
   or to the right.

Excel will automatically fill in months of the year. As you drag, a tooltip

will indicate the last month to be filled in. When you release the mouse

button, the selected number of months will appear.

2. Type “1st Period” into a cell, then select the cell and drag the fill handle;
   Excel will type the remaining periods.

Figure 75 Dragging the fill handle

Figure 76

Months filled in automatically

Figure 77

Class periods filled in automatically