Excel Mac 2016 – Paste Special – Multiply

Multiply the values in the copy area to the values in the paste area.

In this example, we will use a wine menu and we are increasing amount of all wines in 32%

Note: To increase in 32% you need to multiply by 132% or 1.32

Copy the table below or download the template file

Wines Year 6oz 9oz Btl
Baco Noir 2015  17  24  64
Cabernet Franc 2013  23  34  90
Cabernet Sauvignon 2012  28  42  112
Cabernet Sauvignon 2013  32  46  125
Chardonnay 2012  22  33  88
Chardonnay Musqué 2015  15  21  58
Gamay 2015  16  22  61
Mencía 2011  25  37  98
Mencía 2011  25  37  98
Meritage 2013  15  21  58
Pinot Gris 2015  21  32  83
Pinot Noir 2014  28  42  112
Pinot Noir 2015  16  22  61
Privada 2013  22  33  88
Riesling 2013  15  21  58
Syrah 2012  37  55  148
  1. In an empty cell, type the value do you want to multiply, for example, 132% and copy the cell (Command-C)
  2. Select the cells do you want to increase the value
  3. On the Ribbon, click the Home tab
  4. Click the arrow on left side of button Paste, and select Paste Special. You also can use the shortcut key Control-Command-Vexcelmacpastespecialmultiply_1
  5. In Paste Special Windowexcelmacpastespecialmultiply_2
    • Paste – Select Values to keep original format (You must choose it if you enter a % value)
    • Operation – Select Add to increase the values
  6. All values are multipied in 132%
  7. Clear the cell used to hold the 132%excelmacpastespecialmultiply_3

 

Advertisements