Ask Your Question

When I drag a number to another cell to copy it, the value increases by 1 each time. How do I stop this?

asked 2017-05-17 21:43:21 +0200

Alan T gravatar image

I want to copy the exact number, or date, not increase it.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-05-18 01:39:49 +0200

m.a.riosv gravatar image

Drag in combination with [Ctrl] key.

edit flag offensive delete link more


Can't upvote because I'm new but THANKS!!!

mrsclyn gravatar imagemrsclyn ( 2019-06-11 20:12:34 +0200 )edit

answered 2017-05-18 01:52:11 +0200

robleyd gravatar image

Try holding Ctrl as you drag the square box on the corner of the cell.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-05-17 21:43:21 +0200

Seen: 78 times

Last updated: May 18 '17