How to Share MS Excel Data

Share MS Excel Data

MS Excel is highly versatile and supports sharing its contents with other programs. Contents can be shared from MS Excel to MS Word, MS PowerPoint and even non-Microsoft products. This flexibility motivates the users to use MS Excel. Now, the sharing of content is not one way. MS Excel not support sharing its data with other programs, but also data from other programs to be shared in Excel.

The term sharing is technically called as Paste. Therefore, in this tutorial, you will learn different methods of pasting data in and out from MS Excel. This tutorial will be using MS Excel and MS Word.

Paste

The most common and mostly used method of sharing data is general Paste function. In this function, you will copy the contents of Cell Range from MS Excel and copy them into MS Word. You will follow the following steps:

1. Select the contents in MS Excel Sheet.

2. Press Copy from the Clipboard section or press Ctrl + C

Ctrl + C

3. Now switch window to MS Word

4. Place the cursor at your desired position and press Paste from the Clipboard section or press Ctrl + V to paste content

Ctrl + V

The content will be pasted in a tabular form

Paste Special

Another way to paste content is using a Paste Special option. In this option, the program allows you to paste data into your specified manner. You will follow the following steps:

1. Select the contents in MS Excel Sheet.

2. Press Copy from the Clipboard section or press Ctrl + C

Ctrl + C

3. Now switch window to MS Word

4. Place the cursor at your desired position and select Paste Special from Paste Menu in Clipboard Section or press Ctrl + Alt + V

Ctrl + Alt + V

5. Select unformatted Unicode text and click OK.

click OK

6. The text will be pasted in an unformatted manner (plain text)

plain text

More Related Articles For You

    Microsoft Excel Tutorial

Search

Shortcodes Ultimate

 
Follow Us
 
BGP