Paste Special Function In Excel

This topic has been explained in great detail in the video shown below, to learn this topic just play the video and the notes are mentioned below the video.


Paste Special Function In Excel






How To Use Paste Special in Excel

See how to use the Paste Special feature of MS Excel 2007. This Excel tutorial has been created to help you learn microsoft excel online. On http://www.myelesson.org you get excel help and online file download facility. This video lesson covers the entire topic in simple and easy to understand step by step approach.

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.

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.



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

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

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

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

Paste
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

When:

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.

Top part of Paste Special dialog box
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.



Bitmap

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
To add a hyperlink to a separate document or presentation, click Paste Link.

Choose Microsoft Excel
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.








Our Other Services




Read Free Ebooks

myeboook.com

Myebook has 1000's of free ebooks for you. On productivity, health, online income, learning, music and many more, it's free of course!



Buy Excel Course

myelesson.org/product

Become an Excel Guru, Buy the best Excel course. Learn on your mobile, tv & laptop without internet. For COD, Call 9752003788



Create Best Looking Resume

http://www.makecv.org/

At Makecv.org you get to create a amazingly professional looking resume in just 3 steps with our intuitive resume builder!


Download Excel Crash Course


This Excel Crash Course contains the list of topics that cover the most important and used features and formula of Excel . This Excel Crash Course lists 43 major topics in Excel so that you can start using Excel like a pro in the shortest possible time.



Learn Photoshop Web Designing


You can Buy the Photoshop Course to learn Photoshop and start a career in Web Designing and Photo Editing. .



Learn HTML CSS


You can Buy the HTML CSS Course to learn HTML CSS and start a career in Web Designing and Photo Editing. .


Download Full list of Excel Shortcuts


This Excel Shortcuts Complete list is to help you become save time and use Excel like a Master level user. Excel is best used when you know the Keyboard shortcuts because the use of keyboard shortcuts in Excel helps you in completing tasks faster.

I have created a Excel Shortcuts complete list for you to use Excel better, this list has 242 excel keyboard shortcuts which means that it covers almost everything that can be done using shortcuts in Excel.




Full List of Excel Formulas

This is a complete alphabetical list of all the Formula in Excel with a description. You can learn all these formulas on www.Myelesson.org




Convert Numbers to Text in Excel

Now easily convert numbers to Text in Excel with this inbuilt sheet from myelesson.org .  Many times we need the amount in figures to be converted into words. This is a typical requirement for writing checks or any other financial reports. Microsoft Excel does not have standard function available for this requirement. Just download this sheet and then you can convert any number to text in Excel.




List of Most Commonly Asked Excel Questions in Interviews

Here is the list of most asked excel related questions in interviews.  Prepare for this excel questions and you would be able to most of the excel interviews. This list of excel questions covers excel formula, excel analysis, excel reporting, excel charts and more.





Myelesson © 2010 - 2014. All rights reserved.

Do You Want to Become a Expert in Excel ?
Buy The Full Excel Course Now
Enter Your Details & We Will Contact You
Great Choice
Thank You
Ok
Do You Want to Become a Expert in Excel ?
Buy The Full Excel Course Now
Enter Your Details & We Will Contact You
Great Choice
Thank You
Ok