Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Inserting Excel tables into Word
Wish I understood better. Are parts of the columns missing in Word or what?
Also, don't forget to use rightclick on the link, choose Worksheet object, EDIT. This is where you confirm that all your columns and rows are showing. Nothing in the world will fix a problem until you can SEE all the rows and columns in an embedded object from the EDIT view, THEN try to resize by grabbing the corners in small increments, as I spoke of earlier. "Louise" wrote: Thanks again for your speedy reply. I have changed the orientation, i've made the margins as small as i can, adjusted column widths etc, still to no avail. I feel I will have to re-type this table in Word from scratch. Talking to other users of Word/Excel, this does seem to be an extremely common problem - you should be able to import data from one to other without all this hassle. Perhaps this is something that Bill Gates could concentrate on next!!! Thanks again. Louise "How to link or embed objects in Word" wrote: Oh ... for the rest of your question ... Change your Word document to Landscape. Change your left and right AND bottom margin to 0.5". After you link, as in my recent post, the link will HANG beyond your right margin. In Word, you want to be in View, Zoom, Page Width. If you cannot see your right margin, that is ok. Grab the TOP, LEFT of your link. You will see small square black boxes in all corners and middles. In very small increments drag the cursor DIAGONALLY, towards the center. Keep doing it until your right margin is within the right margin. If the bottom falls off your page, you have more work to do. You might change the top margin to 0.5, which I do not recommend, because you need the top margin, particularly if this will be bound. You can decrease your row heights in Excel, then update your Word links (F9). Once you get the entire worksheet showing in Word, then the only problem is vertically. If that doesn't work, then you have to have your worksheet links in multiple pages in Word. My fix here is to link ONLY your Excel header into your Word header. This way, if your link is multiple pages, if your worksheet will be edited often, this prohibits having to constantly relink after changes have been made. What I do to quesss at how many rows I can link in Word and keep testing by relinking till my link fills the page. I note in Excel how many rows it takes to fill the page in Word, THEN i begin playing with the top/bottom margins in Excel, till the page break matches what I have chosen. Now all you have to do is link between page breaks. Every time the document is altered, rows deleted or added, now because your header is in a Word header, all you have to do is F9 to update each link. The MOST you would have to do is to Alt+F9 on the last link and add or decrease the number of rows to show the new last row. Make sense? If not, post again with your question. Again, the key is dragging your link in Word to fit your margins. You HAVE to be careful of your font size. Also, on large schedules, you MUST pay attention to column widths and ensure each column is at their lowest possible width. Check the text column at left; is there room to reduce the column width there. A key in working with large schedules is that sometimes when you print in Word the last column may be missing. This is a que that you only have a few spaces to delete (F9 to update the link each time you make a change to test the result). If more than one column is missing, you have to reduce your column widths, as discussed at beginning of this paragraph. IF that doesn't work, THEN you reduce the font size. Many people erroneously have reducing font size their first choice, but it should actually be a last resort for the best looking worksheet. "Louise" wrote: Is there an easy way to insert an Excel worksheet into a Word document? I have a Word document and want to import quite a large a table I have created in Excel. I have tried Copy/Paste and Copy/Paste Special, however, the size of the Excel table is altered quite drastically and physically will not fit into the Word document, even though in Excel it is well withi the parameters of an A4 piece of paper. I have also used the Insert Excel Worksheet icon within Word and then pasted my information into there, but the formatting changes and still doesn't fit on to the paper. What's the easiest way to do this?? Ive come across this problem loads of times and can't find a solution. Any urgent help would be much appreciated. Thank you. Louise |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
Specific text placement | New Users | |||
How do I create a Word form like corel WP merge documents? | Microsoft Word Help | |||
Wordperfect Office 2000 conversion to Word 2003 | New Users | |||
How do I create & merge specific data base & master documents? | New Users |