Paste Special Add

Do you ever need to convert units, increase or decrease a range of data, or change its sign? Then this technique should work for you. Excel’s Copy > Paste Special > Add / Subtract / Multiply / Divide lets you transform data in place. You don’t need an intermediate column or row. Say, for example,…