How do I stop a cell from incrementally adding up?

[kevin mccormack]

I have a 2 cells merged, the data in the cells are always 1 of three choices ( 2-1/2, 3-1/2, 4-1/2) If I select my choice of the three and try to extend it to the next cell it automatically raises it by 1 with each cell added. For example:
cell A:1 = 2-1/2 when I drag that the next cell
cell B:1 = 3-1/2 then
cell C:1 = 4-1/2 then
cell D:1 = 4-1/2 etc.
I don't have this problem when cells are not merged, is there an alternate way of merging the cells so this does not occur?
Thanks in advance.

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[Bob Umlas]

Hold the ctrl key as you drag.
Bob Umlas
Excel MVP