copy down

[shakey]

How can I prevent this?
Say column C2 has a number in it. Then I copy down and get same number as
desired.
BUT
If I copy the entire line down the number in C2 increases by one on each
line. Nothing in any formula increases the number in C by design.

TIA
SG

 

[Dave Peterson]

Should any of the values be incremented?

If no, then how about rightclicking on the autofill handle (you're autofilling
by dragging that handle, right????) and then drag down.

Then when you let go, you can choose Copy Cells (and not Fill Series).

 

[Bob I]

Try pressing the CTRL key while you drag down.

 

[shakey]

DAVE---BOB
Both methods did just what I needed. Thank you both.
SG

 

[Bob I]

You're welcome, have a great day!

DAVE---BOB
Both methods did just what I needed. Thank you both.
SG