Hi Scott,

Try this
Put 1 in A1
Click on the fill handle and drag down to row 20
Hold down Ctrl and let go the fill handle then let
go the left button.
(To find the fill handle hover your cursor over the bottom right
of the active cell until it turns into a little cross)

Play with a few variations. Put 1 in A1 and 2 in B1
highlight both cells then click on the fill handle and drag
down to row 20. This accomplishes the same thing as before
without the Ctrl button.however if you use the Ctrl
button you will get repeating series of 1 and 2 running
down the column

Now try 1 in A1, then highlight A1 to A4, then grab the fill handle
and drag down, once again see the difference with and without
the fill handle.

Keep playing and you will find all sorts of handy shortcuts.

HTH
Martin

"Scott Hemphill" wrote in message
...
I have a worksheet where i want to number a column sequentially but not
every
row. I put number 1 in column A1 and then put the formula A1+1 and copy
it
down, sometimes i have blank rows where i don't need any numbers,
sometimes i
delete and add rows. Is there a way without just copy and paste to achieve
the same results?
--
Scott Hemphill