Power of Paste Special – Multiply

Talk to you soon.

Prove you're human: Type the code shown.

By clicking any of the above buttons, I agree to the terms & conditions and privacy policy, and I consent to receive updates via SMS or email

+1 236 900 6300

Power BI Reporting:
Beginner to Expert
Power BI | Power Pivot | Power Query | DAX
Microsoft Excel Training:
Business Reporting & Model Building
60+ Formulas | Data Stories | Advanced Reporting & Modeling
Excel VBA Programming
for Automation
VB Programming | Report Automation |
MS-Office Automation

Business Professionals

Techno-Business Professionals

Technology Professionals

Programs & Courses

New

Home

About Us

Programs & Courses

New

Home | About Us | Contact Us

+1 236 900 6300

support@excelgoodies.com

ExcelGoodies WorldwideUK | USA | Australia | Singapore | Phillipinnes

Power of Paste Special – Multiply

For some of you this is already known, but I know there are users who are not aware of the power of the Paste Special Dialog.

For some of you this is already known, but I know there are users who are not aware of the power of the Paste Special Dialog.

Suppose you have been asked to create a budget for next year. The budget will be based on last year’s sales figures and the budget should be 10% more than last year.

As usual, there are several ways to skin a cat. A quick method to achieve it is to use the Paste Special Dialog. The following screenshot shows the details:

First, we enter 1.1 (which represents the 10% increase) in an empty cell in the worksheet.
Next, we copy the source, i.e. the cell that holds the value.
Then we select the targeted range of data that is to be increased with 10%.
Next, we select the command Paste Special.. from the menu by Right-Clicking on the targeted range.
In the Dialog we select the operation Multiply and then hit the OK button.

The output of the operation is shown in the following screenshot: