Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

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

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?
  • 2
1 Solution
Muhammad Ahmad ImranDatabase DeveloperCommented:
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%
Type 1.1 in any cell. Then Copy it  and Paste Special/Multiply the range.

KAOSSAuthor Commented:
Wow! that was so simple thank you!
Muhammad Ahmad ImranDatabase DeveloperCommented:

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now