Excel for Marketing Managers

Multiplication Tables

Multiplication
Tables

Using the Fill Handle to Extend a Series

1. Start with a blank Excel workbook. Leave cell A1 blank.


2. Enter the first two elements of a series.
   In cells A2 and A3, type the numbers “1” and “2”. Select a range containing
   both cells. In the lower right corner of the selection, there is a square dot
   known as the Fill Handle. With the mouse, grab the fill handle and drag
   down to row 13.


3. Extend the series.
   As you drag, a tooltip appears showing the numbers that will be entered in
   the last cell. When you get to row 13, the tooltip indicates that the series
   will extend to 12. Release the mouse button to enter 1 through 12 in the
   cells.

Copying a Range on its Side

1. Copy the range.
   After using the fill handle, the range of A2:A13 will be selected. Use Ctrl+C
   to copy that range. Move to cell B1.


2. Transpose the range.
   From the menu, select Edit → Paste Special. In the Paste Special dialog
   box, choose the checkbox for Transpose. The process of transposing will
   turn data that goes down a column to data that goes across a row.

Figure 70

Selecting the fill handle