create keyboard shortcut for paste special

Just be sure to specify the appropriate operator in step 3.įurthermore, Excel doesn’t complain when the two range dimensions don’t match. You can subtract, multiply, and divide using the same technique. Click OK and Excel adds 1 to the selected values in column A, 2 to the selected values in column B, and 3 to the selected values in column C.

In the resulting Paste Special dialog, select Add.

(In Excel 2003, choose Paste Special from the Edit menu.)

Click the Home tab and choose Paste Special from the Paste option in the Clipboard group.

Select the cells you want to copy to the Clipboard (A4:C4) and press +C.

Using Paste Special, you can turn a rather tedious task into a few clicks! First, you enter the values you want to copy to the Clipboard, that’s values 1, 2, and 3. For instance, let’s suppose you want to add the values 1, 2, and 3 to all the corresponding values in columns A, B, and C, respectively. What you might not know is that you can copy multiple values to the Clipboard. Using this simple technique you can also subtract, multiple, and divide large ranges of values by the same value.

Excel adds the value you copied to the Clipboard to every value in the selected range. (In Excel 2003, you’d choose Paste Special from the Edit menu.) In the resulting dialog, you click Add and then click OK. Then, select the values you want to change and choose Paste Special from the Paste option in the Clipboard group. Enter the number you want to add, subtract, multiply by or divide by and press +C to copy that value to the Clipboard. You probably know that you can add, subtract, multiple, and divide in Microsoft Excel using Paste Special. You can make the process even more efficient with keyboard shortcut combinations. Use Excel's Paste Special feature to calculate multiple values against a data range, at the same time. Use Paste Special to perform calculations while pasting in Excel

Create keyboard shortcut for paste special