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

Posted on 2011-10-28
Last Modified: 2012-05-12
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?
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%
    LVL 29

    Expert Comment

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


    Author Closing Comment

    Wow! that was so simple thank you!
    LVL 14

    Expert Comment


    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    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.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now