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

0 Comments

Paste Special in MS-Excel |0| Paste Special 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 in MS-Excel /Paste Special Shortcuts in Excel

Paste Special in MS-Excel |0| Paste Special 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 |0| 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.

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

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 *