### Mathematical Operators in Paste Special in Microsoft Excel The Mathematical Operators in a Paste special is a feature, used to paste the copied contents in a specific format. Besides this, you can use keyboard shortcuts to perform mathematical operators such as add, multiply, subtract, or divide a specific number to the selected range of cells in a worksheet.

## STEP-1

• Prepare the data table in which you want to add, subtract, multiply, or divide.
• Enter and copy a number in any cell in a worksheet.
• Then select one of the columns that contain numeric data in a data table that you have prepared for adding, subtracting, multiplying, or dividing.

## STEP-2

### To open the Paste Special Dialogue Box for Mathematical Operators, do one of the following.

• Press CTRL + Alt + V, after copying the selected numbers from the cell that you want to add, multiply, subtract, or divide. (or),
• On the Home tab, in the clipboard group, Click the expand arrow of the Paste and then, select the Paste Special after copying the selected numbers from the cell that you want to add, multiply, subtract, or divide. (or),
• Right click on the worksheet, then select the Paste Special after copying the selected numbers from the cell that you want to add, multiply, subtract, or divide.

## STEP-2:

After Paste Special Dialogue has been opened, Do the Following.

• Select one of the mathematical operators.
• Then click Ok
• Now check your column in a data table that you have selected for adding, subtracting, multiplying, or dividing.

Below are the keyboard shortcuts for mathematical operators. Must open the Paste Special dialogue box (Ctrl + Alt + V) before using these shortcut keys. Add Press G → Press Enter key or click OK. Copying any number from one place and Add it to other selected numbers in a range of cells. Subtract Press S → Press Enter key or click OK. Copying any number from one place and Subtract it from other selected numbers in a range of cells. Multiply Press M → Press Enter key or click OK. Copying any number from one place and Multiply it to other selected numbers in a range of cells. Divide Press G → Press Enter key or click OK. Copying any number from one place and Divide it by other selected numbers in a range of cells.