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-V
5. In Paste Special Window
   • 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%