Show All

Create a multiplication table

A multiplication table is a two-variable data table.

1. Set up a worksheet with the following structure.

2. 1 2 3

   A 1 1 =A1*A2

3. Enter a row of values from B3 to the right. For example, 1 through 10.

4. Enter a column of values from A4 down. For example, 1 through 10.
5. Select all cells in the range except cells A1 and A2.
6. On the Data menu, click Table.
7. In the Row input cell box, enter A1.
8. In the Column input cell box, enter A2.
9. Click OK.
10. If you like, freeze the data table by converting the result to their values.

    How?

    1. Select all resulting values in the data table.
    2. Click Copy on the Standard toolbar, and select the upper-left cell of the paste area.
    3. Click the arrow next to Paste , click Values.

    Note  Because the resulting values are in an array, you must convert all of the values to constant values.