Menu

Mathematical Operators in Paste Special in Microsoft Excel

0 Comments

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.

JOIN OUR NEWSLETTER
I agree to have my personal information transfered to MailChimp ( more information )
Join over 3.000 visitors who are receiving our newsletter.
We hate spam. Your email address will not be sold or shared with anyone else.

Leave a Reply

Your email address will not be published. Required fields are marked *