Paste Special In Excel

You can specify formatting when you paste slides, text, pictures, objects, and tables from other programs or the web into your Office application such as Access, Word, PowerPoint, Excel, and Outlook.

Now, rather than using the formula you can use paste special's multiply option here. Select the cell in which you have your%age of increment(I have used 1.2 for increasing the tariff by 20%) and copy it. Now, select the entire range on which you want to apply the calculation. Use shortcut key Alt + E + S to get the paste special dialog box. Copy and paste a range of columns or rows in reverse order with an awesome feature. If you are not familiar with the above formulas and VBA codes, here, I will recommend an easy tool-Kutools for Excel, with its Flip Vertical Range and Flip Horizontal Range features, you can reverse the range of cells vertically and horizontally with only one click.

Paste special in excel not working

But when we use Paste special, we actually saving a ton of time. In Excel picking up a cell or a range with Copy or Ctrl+C is not a simple affair. You might look at the cell as it contains a number, a value that you want. But when you hit Ctrl+C you pick up a bunch more attribute that belongs to the cell. Free Excel Crash Course. Learn Go To Special (F5) with CFI’s Free Excel Crash Course.This course gives you the most important spreadsheet formulas, Excel keyboard shortcuts (Mac and PC) Excel Shortcuts PC Mac Excel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. Range.PasteSpecial method (Excel); 2 minutes to read; o; O; k; J; S; In this article. Pastes a Range object that has been copied into the specified range. Expression.PasteSpecial (Paste, Operation, SkipBlanks, Transpose). Expression A variable that represents a Range object.

Paste Special In Excel

Using Paste Special

Like pictures and other objects, text in a presentation has its own formatting — such as typeface, color, and font size. When you copy text that has different formatting into an Office program, the program, such as PowerPoint or Word, automatically reformats that text to match the text of the destination. However, you can use Paste Special to maintain the original formatting or paste it as a link or a picture, for example.

  1. Cut or copy the slide, picture, text, or object that you want to paste.

  2. Click in your Office file at the place you wish to insert that item.

  3. On the Home tab, in the Clipboard group, click the arrow under Paste, click Paste Special, and then choose one of the options below.

    Tip: If you'd prefer to use the keyboard you can press CTRL+ALT+V to invoke Paste Special.


To specify the format that you want to paste the slide, text, or object as, click Paste, and then use the table below to select a format from the Use this format list.

Use this format


Formatted Text

You want the text to retain the formatting of the text from the other program or web page.

Unformatted Text

You want the text to take on the formatting of the Office program you're pasting to.

Microsoft Office Drawing Object

You want the contents of the Clipboard to appear as a Microsoft Office drawing object.

Picture (GIF)

You want the contents of the Clipboard to appear as a Graphics Interchange Format (GIF) picture.

The GIF file format is limited to 256 colors, and is therefore most effective for scanned images, such as illustrations, and less effective for color photographs. GIF is also a good file format for line drawings, black and white images, small text that is only a few pixels high, and animation.

Picture (JPEG)

You want the contents of the Clipboard to appear as a Joint Photographic Experts Group (JPEG) picture.

The JPEG file format supports 16 million colors and is best suited for photographs and complex graphics.

Picture (PNG)

You want the contents of the Clipboard to appear as a Portable Network Graphics (PNG) picture.

The PNG file format is similar to GIF but it provides better color support. It compresses solid areas of color while preserving sharp detail, such as the detail in line art, logos, or illustrations with text.

You can save, restore, and re-save a PNG image without degrading its quality. Unlike GIF files, PNG does not support animation, and some older web browsers and applications do not support PNG.

Picture (Windows Metafile)

You want the contents of the Clipboard to appear as a Windows Metafile Format (WMF) picture.

You can save a picture as a 16-bit graphic (for use with Windows 3.x and later).

Picture (Enhanced Metafile)

You want the contents of the Clipboard to appear as an Enhanced Metafile (EMF) format.

You can save a picture as a 32-bit graphic, which supports more sophisticated graphics functions.

Device Independent Bitmap

You want the contents of the Clipboard to appear as a Device Independent Bitmap (DIB), such as a slide acting as a graphic for use on web pages.

A DIB is a representation (that consists of rows and columns of dots) of a graphics image in computer memory. The value of each dot (filled in or not) is stored in one or more bits of data.


You want the contents of the Clipboard to appear as a bitmap.

The Microsoft Windows BMP format can display millions of colors. Because it is supported by several programs, it is an extremely practical file format to use when you are providing an image to someone who may not have the program in which you created the image.

Paste Link

How to paste special

To add a hyperlink to a separate document or presentation, click Paste Link.

Note: The Paste Link option is unavailable if you cut or copied content from a document that does not support the Paste Link option, or if the document that you are attempting to link to has not been saved.

To paste the content as an Object Linking and Embedding (OLE) application icon (rather than pasting the actual content), select the Display as icon check box. You can click the icon to open the application, and then view the content. The Display as icon check box is only available if you use Paste Link or if you paste the content as an OLE object. You can then can change the icon for the content that you pasted.


Pastes a Range object that has been copied into the specified range.


expression.PasteSpecial (Paste, Operation, SkipBlanks, Transpose)

expression A variable that represents a Range object.


NameRequired/OptionalData typeDescription
PasteOptionalXlPasteTypeThe part of the range to be pasted, such as xlPasteAll or xlPasteValues.
OperationOptionalXlPasteSpecialOperationThe paste operation, such as xlPasteSpecialOperationAdd.
SkipBlanksOptionalVariantTrue to have blank cells in the range on the clipboard not be pasted into the destination range. The default value is False.
TransposeOptionalVariantTrue to transpose rows and columns when the range is pasted. The default value is False.

Return value

Paste special in excel



This example replaces the data in cells D1:D5 on Sheet1 with the sum of the existing contents and cells C1:C5 on Sheet1.

Paste Special In Excel Function

Support and feedback

Paste Special In Excel 365

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.