Right-click the cells that you’re pasting to and select “Paste Special” in the shortcut menu.Īdd, Subtract, Multiply, or Divide Using Paste Specialįor basic numbers, decimals, and currency, you can choose from All, Values, or Values and Number Formats in the Paste section of the window.Click the Paste drop-down arrow in the ribbon on the Home tab.Then, do one of the following to access paste special.

To copy, you can press Ctrl+C or right-click and select “Copy.” So, you’ll start by copying the data and then selecting the cell(s) that you’re pasting to. Access Paste Special in Excelįor each of the aforementioned calculations, you’ll open the Paste Special dialog box in Excel. You can perform these types of calculations quickly on a large number of cells simultaneously with Excel’s paste special operations. Or, perhaps you have inventory that you want to increase or decrease by unit amounts. Maybe you have prices that you want to increase or costs that you want to decrease by dollar amounts. But did you know that you can use Excel’s paste feature to perform simple calculations? You can add, subtract, multiply, or divide in a few clicks with paste special in Excel. You might copy and paste data often in your spreadsheets.

Paste link in excel 2016