Maxflyer

I have a spread sheet that has numerous cells with different values in (just values not formulas). Is there any easy way to apply a calculation to all of them at once, i.e. I may want to increase them all by a certain percentage or add an additional amount to all of them?

Any help greatly appreciated.

MF

Saab Dastard

1. Select the cell whose formula you need to copy
2. Select the copy option from the edit menu. This copies the formula.
3. Now select all the cells to which you want to apply the formula
   Hint: To select many cells at the same time, you can click and hold your mouse button on the first cell, and drag it and then release it on the last cell.
4. Choose paste from the edit menu.
5. The calculated results should appear in all these cells.

__________________
You can't have everything - where would you put it?

Thor Nogson

If I understand it right, there is another way of doing this.

If, for example, you wanted to add 10% to all the cells in a selection, first put the value 1.1 into another cell. Copy that, and then select all the cells you want to increase. Using the menus, do edit -> past special -> multiply

That should do it. Of course you can do add/subtract and divide as well.

You can also do it with Formulas as SaabDastard has suggested.

TN

Saab Dastard

Thor,

That is brilliant, much better than copying formula! Thanks, I will find that very useful myself - I had no idea you could do that

SD

__________________
You can't have everything - where would you put it?

Maxflyer

Thanks for your help guys. Problem solved.

MF