How do I stop a cell from incrementally adding up?

  • Thread starter kevin mccormack
  • Start date
K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Extracting data from Multiple columns to a Single row 3
Creating Labels Over 3-Up Image 2
Possible? Variable X and Y data sources and Auto Charting 0
concatenate entries from a column into a cell by logical AND withanother column 2
Data selection from one worksheet into a second worksheet. 1
Locate text in range (multiple occurrences) and report other cell insame column? 25

Top