1. Select cell D3.
2. Right click, and then click Copy.
3. Select the range A1:B8.
4. Right click, and then click Paste Special...
5. Click Multiply.
Note: you can also Divide, Add or Subtract a value.
6. Click OK.
Note: all values are increased by 10 percent. Without this feature, you would have to create a temporary range (with formulas that multiply the values in the range A1:B8 by 1.1) and then replace the range A1:B8 by copy and pasting the temporary range as values.
Post a Comment
0 comments
Dear readers, after reading the Content please ask for advice and to provide constructive feedback Please Write Relevant Comment with Polite Language.Your comments inspired me to continue blogging. Your opinion much more valuable to me. Thank you.