Hi Joe,

Also have a play with the fill handle and click and drag.

Open a new sheet and put 1 into any cell, while the cell is still active
hover the cursor over the bottom right corner and it will change
to a cross, click and drag the cross down say 20 rows, keep the left
button depressed then press and hold ctrl, the little window next to your
cursor will change from 1 to 20, let go of the left button and all the
cells will be filled 1 to 20.

Now try putting say 15 in one cell and 22 in the cell beneath it, then
highlight both cells and do the click and drag, this time the default will
increment each cell by 7 but if you press ctrl it will revert to alternating
sequences of 15 and 22.

Keep playing with different options and you'll find all sorts of handy
tricks.

HTH
Martin

Pefect! Thank you very much Biff and MartinW!
Joe