PPRuNe Forums - MS Excel Question

PPRuNe Forums (https://www.pprune.org/)

- Computer/Internet Issues & Troubleshooting (https://www.pprune.org/computer-internet-issues-troubleshooting-46/)

- - MS Excel Question (https://www.pprune.org/computer-internet-issues-troubleshooting/234333-ms-excel-question.html)

Maxflyer

12th July 2006 08:18

MS Excel Question

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

12th July 2006 08:46

Select the cell whose formula you need to copy
Select the copy option from the edit menu. This copies the formula.
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.
Choose paste from the edit menu.
The calculated results should appear in all these cells.

Thor Nogson

12th July 2006 10:16

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

12th July 2006 12:47

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 :ok: :ok: :)

SD

Maxflyer

12th July 2006 12:48

Thanks for your help guys. Problem solved.

MF

All times are GMT. The time now is 02:50.