Once mo

Say I want a 10 x 10 multiplication table.


As you'd done, put 1-10 in A2:A11 and B1:K1

In A1, enter =L1*L2. Pick two blank cells that will *not* be in the
table

Select A1:K11

Choose Data/Table

In the dialog that opens, enter L1 in the row input cell, and L2 in the
Column input cell (e.g., the same cells you used in A1).

XL will fill in the products.

See "Create a two-variable data table" in XL Help for more.


In article ,
(Jim) wrote:

The second way though didn't work for me, and I wonder if you can
re-explain the 2nd method.