Menu

Paste Special Feature Shortcuts in Excel 2019, 2016, 2013, 2010 and 2007

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 Keyboard Shortcuts in MS-Excel 2019, 2016, 2013, 2010, and 2007.

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 Feature 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 a 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 a 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 Feature Shortcuts in excel, read the related posts related to Paste Special given below.

Related Posts:

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>>

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 *