The problem is, the 1 and 2... are behind and = sign. The drag does not have
the desired effect.

"MarkN" wrote:

Hello,

There's a few ways of doing what you want. When you create the numbers in
the first place, if you enter 1 in the first cell and 2 in an adjacent cell,
you can highlight both and drag the fill handle to create incrementing
numbers. If you are using the row function you need to highlight the numbers
and copy them, choose a cell to paste to and righ-click (or from the Edit
menu), select Paste Special and choose Values.
--
Hope this helps,
MarkN


"sb1920alk" wrote:

I have a formula that has the number 1 in it. When I copy down (pull) I would
like the 1 to increase to 2, 3... with each row I pull it down, but if I copy
and paste I would like it to remain 1 regardless of where I paste it. Is
there a way to do this?

ROW(A1) works for copying (pulling) down but it also adjusts when I copy and
paste and I don't want it to.

Thanks,