Data Transfer From Excel To Microsoft word- MS Word is amazing to use in terms of making any table or handling any data in it but what about if we want to transfer any data from excel to word? of course we have many ways to do it. So here we will explore how can we transfer data from excel to word without any software. we can simply transfer any excel data to word.
Data Transfer:- Nowadays people think that data transfer is a little tough task because they are not aware of it that how to do it however some people do that easily if they have knowledge about it. Now the challenge is, How can we go ahead and transfer this data or any work data from ms excel to word? For this, there is an absolute full explanation below about it. let us go through it now.
Also, it needs words in the way that if we want to make any changes in ms word, that change must be updated automatically in Microsoft excel also.
Process:- First of all to transfer any data from ms excel to ms word, we need to open our excel spreadsheet where the data we have and also open ms word there we need to transfer the data then copy all data and then go to ms word file and do click paste special.
Once this option gets clicked we will have this page coming up. look at below the image.
| Data Transfer from MS Excel to MS Word |
But make sure both files must be saved already because it does not perform or work in unsaved files. so before doing it, please check both files (excel and word) must be saved already then it will only work.
Now please check the image carefully. here we will click this option that we have on the left side of this image named PASTE LINK. After clicking it now again we got a few options in the box right-hand side which you easily see in the image below.
 |
| Data Transfer from excel to word. |
Now per the image, we have above, there are 2 options to save this file.
1). PASTE
2). PASTE THE LINK
we have these 2 options to perform in different ways for different conditions.
Nut Now we have to use the 2nd option which is PASTE LINK once we click this button then we get again these many options like:-
1). Microsoft excel worksheet object - The Worksheet object is an individual from the Worksheet selection. The Worksheets selection contains all the Worksheet objects in an exercise manual.
2). Formatted text (RTF) - Windows Metafile (WMF) is a picture document design initially intended for Microsoft Windows during the 1990s. The first Windows Metafile design was not gadget autonomous (however could be made all the more so with arrangement headers) and may contain both vector illustrations and bitmap parts. It acts likewise to SVG documents. WMF records were later supplanted by Enhanced Metafiles (EMF documents) which accommodated gadget autonomy.
3). Unformatted Text - If we copy any file from word to any other word document then it might raise an issue then simply use PASTE SPECIAL and click this option to solve.
4). Pictures (Windows Metafiles) - It stands for an image file format that was basically invented by Microsoft windows in 1990.
5). Bitmap - Bitmap works like a memory organization that stores digital images.
6). Word Hyperlink - it can be added to any picture.
7). HTML Format - It stands for HyperText Markup Language.
8). Unformatted Unicode text - It keeps the content as same in only text format. let support if you need to copy something in text format and want to paste that somewhere so we can select this option in PASTE SPECIAL and it will keep the only text as in content.
Here we have to select this particular option Microsoft Excel Worksheet Object and now hit OK. Now you will see in the video that we have transferred the data from ms excel to ms word successfully. Now the question is what is the benefit of it?
Question:- Do we have to click only that option Microsoft Excel Worksheet Object only?
Answer:- Yes. We have to click only this option which is Microsoft Excel Worksheet Object and we have done the same here too. Because now whatever changes would be made in that ms excel file those changes will automatically be updated thereby click the update link option.
this option will come on on ms word file document by doing the right click of the mouse and selecting the option update link or file and changes would be updated successfully.
That s all now we have learned how to transfer the data from ms excel to ms word. it has the only benefit that changes also would be made in that MS word made if any were done in the previous ms excel file.
The
other features also we have which we have seen above. we can use these features
for different scenarios.
1). Microsoft excel worksheet object - A Worksheet is a collection of cells composed in rows and columns. Every worksheet contains 1048576 lines and 16384 segments and fills in as a big size of the table that permits you to arrange data. Commonly, an exercise manual contains a few worksheets with related substances and just each of the worksheets is dynamic in turn.
2). Formatted text (RTF) - RTF stands for Rich Texts Format. we use this file for creating formatted text files.
3). Unformatted Text - This is a file that does not have a proper format.
4). Pictures (Windows Metafiles)- Windows Metafile ( WMF) is a picture document design initially intended for Microsoft Windows during the 1990s. The first Windows Metafile design was not gadget-independent (however could be made all the more so with arrangement headers) and may contain both vector illustrations and bitmap parts. It acts likewise to SVG documents.
WMF records were later supplanted by Enhanced Metafiles (EMF documents) which accommodated gadgets independently.
5). Bitmap -
6). Word Hyperlink
7). HTML Format
8). Unformatted Unicode text
