dragging a number without it changing

[awhite1]

Hello I have what I think will be a very simple question. How do i drag a cell to copy into other cells without the number changing? example: I type 20 into a1, i want to drag it to copy 20 into the next few boxes but instead it is changing the cells by 1 each time. i have one spread sheet that does what i want and one that does not but i cant find what the difference is.

 

[jondavis1987]

If the merged cells have to stay your only other easy option is to hold the control button while you drag the cells to copy.