Paste Special in Excel & Word with No.1 Shortcuts ​

Paste Special in Excel & Word with No.1 Shortcuts

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

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

Paste Special in Word is explained after completion of the Paste Special Shortcuts in excel. Or use table of contents to navigate easily (given below the picture).

To Launch the Paste Special Feature Dialogue Box in excel, 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 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

Image Mathematical Operators in Excel

Keyboard Shortcuts for Mathematical Operators in Excel

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

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.

Steps to follow in using the Paste Special in Microsoft Word:

Cutting the contents | paste special in microsoft word

Image on Paste Special in Microsoft Word

  1. Go to the Home tab
  2. Enter and select the text with some format you want
  3. Then cut or copy the text (to put it on the clipboard)
Paste Special in microsoft word

Image on Paste Special in Microsoft Word

4. Now click on the drop-down arrow of the Paste

5. Then click on the Paste Special, now automatically a window Paste Special Window opens

6. After that, choose one of the text formatting options given in the window. For example, Formatted Text (RTF).

7. Then  click OK

Now, let's discuss all about the Paste Special Format in Microsoft Word:

Microsoft Word Document Object:

The feature Microsoft Word Object Document is one of the content format options to paste the contents of the clipboard. After the contents of the clipboard have been pasted in this format into the word document, even if you move it or move any other objects around it the whole body of this content never degrades as it was before.

Microsoft Word Document Object (Display as a icon):

This feature allows you to Pastes the content of the clipboard as a Microsoft Word Object icon. To edit the content, you need to open (Microsoft word document object) it by double-clicking.

Formatted Text:

In this feature, you can paste the contents of the clipboard without degrading (as if it was before cutting or copying) as a Real-Time Formatted Text.

Unformatted Text:

It helps to paste the contents of the clipboard without any Formatting as a Plain Text.

Picture (Enhanced Metafile):

This feature allows you to paste the contents of the clipboard as a Picture (Enhanced Metafile)

HTML Format:

This feature allows you to paste the contents of the clipboard as a Hyper Text Markup Language (HTML). The HTML format is used on the website.

Unformatted Unicode Text:

It allows you to pastes the contents of the clipboard without any formatting with character encoder as a Plain Text. Unformatted Unicode Text is a universal standard character accepted by all system software in the world.

Related Topics: