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