Check out some similar questions!

scandurica · Mar 4, 2007, 05:33 AM

I have a table with more than 10000 lines and I did a formula on the first line and I tried to copy it with Paste special to the other lines. After that the formulas in the other lines are good but all the values are the same and equals line one. It must be a setting.Which one?

SHAVED · Mar 4, 2007, 05:53 AM

Could you please clarify what formula you did in the first line. Is it multiplication, division, addition or subtraction? In Excel table 10000 lines means 10000 rows. Give some more details what you want to copy and what is the formula. In your table you just copied and pasted the formula which is meant only for the first row.

scandurica · Mar 4, 2007, 06:01 AM

I did let's say C2=A2+B2 . Then I copied formula to all rows in C column.And the result looks like this:
A B C
1 1 2
1 2 2
1 3 2
1 4 2
...
...
It doesn't matter what formula I use , the result is the same: same value like first row.

SHAVED · Mar 4, 2007, 06:07 AM

Ok, copy (the formula from c2) > paste special > chose Formulas & Number formats. You will get the correct answers.

scandurica · Mar 4, 2007, 06:12 AM

Sorry, same problem.
Where I work , we have over 90 computers and on some of them works. What is wrong with the others?

ScottGem · Mar 4, 2007, 06:21 AM

You shouldn't be using Paste Special. There is no need for it. Paste Special allows you to copy a formulas and convert it into the Result. That's not what you want. If you select cell C2, there should be a "handle" (a small square) in the right right corner of the cell. Grab that handle with the mouse cursor and drag it down the number of rows you need. This will copy the formula as a relational formula, meaning that the cell references will change as the cell changes. So Cell C3 will now show A3+B3, etc.

scandurica · Mar 4, 2007, 06:26 AM

I have tried in all modes: Paste special, Drag, Double click on the handle. None of this works on my computer , but on other computers works all.

ScottGem · Mar 4, 2007, 06:33 AM

Even if you copy one cell to the next the Relative addressing doesn't work? What version of Excel are you using?

I don't see any way of turning off relative addressing

SHAVED · Mar 4, 2007, 07:10 AM

It looks you have some problem with your excel. Normally it should work with dragging as told by Scotgem. From your post I noticed that you are more familiar with copy and paste that is why I suggested to copy and paste special with formulas & number formats. Let me see if I can sort out your problem.

Ok Now. Try the following.
You are now doing the formula in column C. Before creating the formula in C2 highlight column C. In Edit Menu Click Clear and Click All. Now you create the formula in C2 and drag the formula to the bottom cells using the fill handle. I hope this will work.

scandurica · Mar 5, 2007, 01:40 AM

It doesn't work. Sorry and thank you all for trying. It must be the excel.

ScottGem · Mar 5, 2007, 06:39 AM

I've never seen it not work, so try uninstalling and reinstalling Office.

scandurica · Mar 5, 2007, 06:59 AM

It was the excel. The IT guys solved it. I don't know what was the problem. They say : it was no problem. :)

ScottGem · Mar 5, 2007, 07:01 AM

I'd be really curious to know how that solved it.

scandurica · Mar 5, 2007, 07:09 AM

A woman from my floor called them in the morning and they did something on hers computer (she doesn't know what :) ) and now it works. I was currios to, but they said to me : it was no problem. I posted on this site because I needed this yesterday. Thank you all again.