Paste Special Feature Shortcuts in Excel | 2020 Special

0 Comments

Paste Special Feature Shortcuts in Excel

The Paste special is a feature, used to paste the copied contents in a specific format. Using this feature, you can paste several formats like, formulas, values, formats, comments, data validation, number formats. Also, you can add, multiply, subtract, or divide a specific number to the selected range of cells in a worksheet. To use Paste Special feature in excel, follow the shortcut keys given below the picture.

To open the Paste Special Feature Dialogue Box, do one of the following.

  •  Press CTRL + Alt + V,  after copying the selected content from the cell.
  • 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 content from the cell.
  • Right click on the worksheet, then select the Paste Special after copying the selected content from the cell.
Paste Special Feature Shortcuts in Excel

Image on Paste Special Feature Shortcuts in Excel

After opening the Paste Special dialogue box as explained above the picture, use the shortcut keys given below to paste any content format that you have copied the content from the selected cell.

Paste Special in MS-Excel | Paste Special Shortcuts in Excel:

Paste Special Option

Keyboard Shortcut

Description

All

Press A → Press Enter key or click OK.

Paste all data with all formatting that you have copied the contents from the selected cells.

Formulas

Press F Press Enter key or click OK.

Paste the unformatted content with formulas that you have copied the contents from the selected cells.

Values

Press V → Press Enter key or click OK.

Paste the content without formula that you have copied the contents from the selected cells.

Formats

Press T → Press Enter key or click OK.

Paste only formatting (not content) that you have copied from the selected data.

Comments

Press C → Press Enter key or click OK.

Paste only comments which are applied to the cells.

Validation

Press N → Press Enter key or click OK.

Paste only data validation that you have applied to the contents from the Data tab, in the Data Tools group.

All using source theme

Press H → Press Enter key or click OK.

Paste all the contents along with source theme formatting from the selected data in the cells, which are applied with theme format from the layout tab.

All except Borders

Press X Press Enter key or click OK.

Paste all the contents without borders that you have copied the contents with borders.

Column Widths

Press W Press Enter key or click OK.

Paste or apply the same column width that you have copied from the selected cells.

Formulas and Number Formats

Press R Press Enter key or click OK.

Paste only number formats and formulas that you have copied the contents from the selected cells.

Values and Number Formats

Press U → Press Enter key or click OK.

Paste only number formats and content without formula that you have copied the contents from the selected cells.

All Merging Conditional Formatting

Press G → Press Enter key or click OK.

Paste all the contents along with source theme formatting and Conditional Formatting from the selected data in the cells, which are applied with theme format from the layout tab, and Conditional Formatting from the Home tab, in the Styles group.

Paste Special Operators

Keyboard Shortcut

Description

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.

Mathematical Operators in Paste Special

The Mathematical Operators in a in Microsoft Excel 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 ; Mathematical Operators in Excel

  • 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; Mathematical Operators in Microsoft Excel

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-3; Mathematical Operators in Microsoft Excel

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.

Mathematical operators in ms-excel

Keyboard Shortcuts for Mathematical Operators in Paste Special

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.

After completion of Paste special Shortcuts in excel, read the related posts related to Paste Special given below.

Related Topics:

Paste Special in Microsoft Word: The Paste Special is a feature that allows you to paste the content with several formats such as a Microsoft Word Object, Formatted Text, Unformatted Text, Picture file, Html format, and Unformatted Unicode Text. These are explained below. Read More>>

Paste Special in MS-Excel |0| Paste Special Shortcuts in Excel

Leave a Reply

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