2.Switch to Word.
3.In Word, triple-click the paragraph that says "Put my Excel chart here". (That selects the whole paragraph and its paragraph marker.)
4.Now, paste the picture.
•In Word 2003 and earlier versions, do Edit > Paste Special and choose Picture (Enhanced Metafile).
•In Word 2007 and Word 2010, on the Home tab, click the bottom of the Paste split button and choose Paste Special. Then choose Picture (Enhanced Metafile).
•In any version, if you want to link the Excel workbook and the Word document (so the Word document will update whenever the Excel workbook changes, then click the Paste Link option). And click OK.
•In Word 2003 and earlier versions, double-click the chart or range you have just pasted, so you see the Format Picture dialog box. At the top of that dialog box, click the Layout tab. On the Layout tab, click In line with text and click OK.
6.Done! You now have a landscape chart or region of a worksheet in your Word document. Use File > Print Preview to check. To fine tune the formatting, or sort out headers and footers, read on.
FOLLOW THESE steps Embed Excel Files into Word.
•1 Open Microsoft Word. You can either open a blank document or an existing document.
•2 Click on the location in your document where you wish to embed your spreadsheet.
•3 Go to the "Insert" menu and select "Object" to open the wizard.
•4 Click the correct tab. "Create New "allows you to create a new file and then embed it into your Word document, while "Create from File" allows you to browse for an existing file. If you want to create a new file, choose "Microsoft Excel Worksheet" from the drop-down list, and check "Display as Icon" to only display the spreadsheet as a clickable icon. If you are going to create a spreadsheet from file, browse your files and select the spreadsheet you want to embed. Choose to display the spreadsheet as an icon or link as well as the full object.
•5 Click "OK" when finished with Step 4 to embed your object. If you didn’t choose to display the spreadsheet as an icon or link, you will see the first sheet of the workbook in your Word document. Click the spreadsheet object to view any other sheets and also to change data.
×
If you already have them in another file ...you can try to just copy /paste them ..but in this case you might end up just with the data and no tab ...cause sometimes it do not copy the whole tab ....and my advice in this case is try with insert button ..and than try to browse fro the file you need to insert and see if it works ..if it is not working you will have to choose insert ..excel sheet ..and after that either manually write the data ..or try to copy /paste the data from the other tab ..It might just work and fit in the new one ..if you choose to make it the same ..
But I think it will work with insert ..and browse for the file and insert it all at once..
Unfortunately ..I just checked and will not work ...you will have to build it manually into the word...cause if you try to copy /paste will copy just the written data without the tab itself ...and if you try to copy the data over the tab in word..it will overwrite the tab and end up with the data only ...so ..you have to click insert tab ..from the list choose excel spreadsheet ..and the data you have to complete manually ..
I found another way to insert the tab from the excel file directly ..without being needed to write it again ..but you will not be able to make modifications on it ..
you need a photo program like the one I will link below ..and in that program it has a capture feature..and if you open the excel tab ..and make a region capture with the tab itself..it will be save like a JPG ..and you will be able to insert like a photo after that ...In case that you make a paper and you need the tab inside just like a reference ..and not to be modified after ..this is the faster solution ..It will take about 2 minutes to install the program ..and when you open it ..on the primary menu you have the feature called screen capture..
choose it ..and open the excel file ...than choose capture region ..crop the region with care ..by click in the left corner and guide to the corner in the lower right ..save the capture on desktop from the photoscape program ..and after that just insert the jpg picture with the tab in the word..
This will be helpful if you have to make multiple insertions ..and you do not need to modify the content after ..
Here is the program I mentioned..
http://www.mediafire.com/file/mzzjojmljj...
for the graphs and tabs ..just make them smaller to fit all ...on the page ,,,and for the color ..just get to more..and then adjust the color by eye ....Another thing ..if you click in front of a graphic or a tab ...and than press space it will move just like you move a row..or a word..so ..If I ware in your place and insert 3 tabs or graphs ..I would put the 3rd in the middle....and for graphics..is better to insert than copy paste ..this way you have the original quality ..and you can easy change the size from the corner..after that you can move it by clicking in front of it ..left low..and press space to move ..
×
142 views
Usually answered in minutes!
Thank you for your solution, for now it is fine to insert the excel file in 2007. What about PPT file?
Should I just copy and paste using sizing tool I have or should I insert from the insert tab...choose the graph in my drive,, what is the difference? Also How to delete the graph's background lines I just can not erase the background data line by right click, choose the settings.
Somehow my second question has been deleted and not transffered to you. It seemed like I asked the same question twice by paying twice. Could you help me out with this second question that I submited which somehow could not transffered to FixYa?
I am writing a report with graphs and tables with words using WORD as a master and PPT and EXCEL for graphs. I am using master document using outlines.
The purposed outline goes like this.... seperate the top and the bottom, and on the top part, write the paragraphs and on the bottom part, add two graphs and tables in parallel.
The thing is, If I create outlines by seperating section for each part. I can not put the third graphs up on the bottom right of the first page.What I did was copy and paste the third section graphs and words on to the left bottom empty space but on the outline this part can not be appeared.
How can I put the third section parts on the left bottom first page to make the sheet look better?
Thank you for your cooperation in advance.
Hi.Somehow my second question with payment could not be transffered to your side and I have got an email saying that in replacement I could get another assistance for free or get my money back. Could you help me out with this question belows?
In regard to using color pallette, I have an example of turquoise 50% but I need to make 5% turquoise. I know that I have to add three numbers for the color but How to refer the known turqupose 50% color code to get 5% turquoise color?
×