Thursday, 31 January 2013

How to multiply large amount of numbers in Excel by using Paste Special

Sometimes you may have a need to multiply large amount of Excel worksheet's numbers by some specific number. E.g. you want to make all numbers negative or multiply them by 100. Instead of doing this routine task manually "by hand", you can use this easy trick and save lot of time:
  1. Write multiplier to one cell and copy it to clipboard (Shortcuts ctrl + c in Windows and cmd + c in Mac)
  2. Select cells you want to multiply
  3. Open context menu and select Paste Special...
  4. Check Multiply and press OK
    --> all selected cells are multiplied by the number you copied!
Following video demonstrates this in action:

No comments:

Post a Comment