Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
HOW TO INSERT A EXCEL FILE INTO WORD & VICE VAERSA?
|
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Insert - Object - create from file
Same process either way "VISHNU60IN" wrote: HOW TO INSERT A EXCEL FILE INTO WORD & VICE VAERSA? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Vishnu,
Select and Copy the Excel stuff. In Word, put the cursor where you want it, do Edit - Paste Special -Microsoft Excel Object. This is called embedding, and there are some things to consider. The entire Excel file (all worksheets), not just the selected area, are embedded in the Word file, though you see only the part you'd selected. To view this in Word doesn't require the user have Excel, but if he does, he can double-click, it into edit mode, and can view and change any part of the original workbook file -- any worksheet. This embedded file is a copy of the original -- it's not linked to the original (unless the link option was used in the Paste Special dialog), so if the original changes, this doesn't. It can make the Word file quite a bit larger, since the entire Excel workbook file is embedded. The same is generally true for embedding a Word document in Excel. You may just want to copy the Excel stuff and paste it into the Word document. That will create a table, and it'll look similar to the Excel stuff. It will be editable in Word (it's a Word table). It won't include anything but the selected part of the Excel file. When pasting Excel stuff into Word, if you use Paste Special, but not Microsoft Excel Object, but some of the image options (picture, bitmap, etc.) , it will look exactly like the Excel stuff, but won't be editable -- it's not a Word table in this case. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "VISHNU60IN" wrote in message ... HOW TO INSERT A EXCEL FILE INTO WORD & VICE VAERSA? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SQL Server -- Bulk Insert from Excel to SQL Server | Excel Discussion (Misc queries) | |||
Changing the Insert Row / Column Default | Excel Discussion (Misc queries) | |||
insert picture | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions |