Applying 1 formula to multiple cells simultaneously

N

nonapp2

I have got a situation at work and I need some help:
I've got 3 columns of figures and I need to increase them all by 25%.
Any help would be greatly appreciated.
P.S. I'll not be able to hide any columns.
Thanks,
nonapp

Nonapp
Carpe Diem!
 
L

Lars-Åke Aspelin

I have got a situation at work and I need some help:
I've got 3 columns of figures and I need to increase them all by 25%.
Any help would be greatly appreciated.
P.S. I'll not be able to hide any columns.
Thanks,
nonapp

Nonapp
Carpe Diem!

Try this:

In any non used cell you put the number 1.25
Select that cell and copy it, e.g. by CTRL+C.

Next, select all the cells in the three column that you want to
increase.

Right click and select "Paste Special"

In the dialog box that apperas you select the radio button marked
"Multiply" and then you click on the "OK" button.

Now you can delete the 1.25 in the non used cell. It is not needed
anymore. All cells that you select should now have been increased by
25%.

Hope this helps. / Lars-Åke
 
N

nonapp2

That did the trick! Thank you so very much. I can't tell you how much
work that will save me! I had looked everywhere and couldn't find
anything on this process.

Perhaps you can help me with ONE more thing that I haven't been able
to figure out?
Is there a way to scan numbers in (as in OCR) directly from Excel?
TIA
nonapp

Try this:

In any non used cell you put the number 1.25
Select that cell and copy it, e.g. by CTRL+C.

Next, select all the cells in the three column that you want to
increase.

Right click and select "Paste Special"

In the dialog box that apperas you select the radio button marked
"Multiply" and then you click on the "OK" button.

Now you can delete the 1.25 in the non used cell. It is not needed
anymore. All cells that you select should now have been increased by
25%.

Hope this helps. / Lars-Åke

Nonapp
Carpe Diem!
 

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

Top