One way:

You need to use a mix of absolute and relative referncing:


=$A2 * B$1

then you can drag.

It's even easier to use the Data/Table function. Enter, say, =IV1*IV2
in A1. Select your 100x100 grid. Choose Data/Table and enter IV1 in the
rows input cell box and IV2 in the columns input cell box, then click
OK. XL will fill in the table for you.

In article ,
(Jim) wrote:

Hi,

I thought it would be simple to set up a times table in my Excell
spreadsheet, but I'm baffled.

I want to have a column of values (1 to 100), and a row of the same
values.

I thought I could then click in the next colum over and enter this
formula: =A2*B1 hit enter, and then autofill the fields, by
dragging the corner of the cell over so many cells as I want.

But it doesn't work. It seems logical enough to expect the autofill
feature to work this way (excel 97), but it doesn't

Please help,
Thanks,
Jim