Solved

# Can you do the same calculation to multiple cells at the same time

Posted on 2011-10-28
206 Views
I have a spread sheet with rows and rows of numbers. I would like to update all of the numbers in 20 rows (12 columns) by 10%.
Is that possible?
0
Question by:KAOSS

LVL 14

Accepted Solution

Let's say you have a list of values in A1:A100 and you need to increase these values all by 10%.

1. Enter the number 1.10 into any blank cell and then Copy it
2. Now select the range A1:A100 and go to Edit>Paste Special
3. Choose Values from under Paste and then Multiply under Operation and click OK.

All value will now have increased by 10%
0

LVL 29

Expert Comment

Type 1.1 in any cell. Then Copy it  and Paste Special/Multiply the range.

Leon
0

Author Closing Comment

Wow! that was so simple thank you!
0

LVL 14

Expert Comment

cheers!
0

## Featured Post

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
Sometimes we don't want to show zeros in our Excel spreadsheets. This is sometimes most evident in our charts. Look at the chart below, all the zero values are visible. I think that all will agree with the fact that zero values are not looking nice …
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.