copy down

  • Thread starter Thread starter shakey
  • Start date Start date
S

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
 
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).
 
Back
Top