However, all the text will be in native Word format, so that you can re-format if required. The Excel cell layout will be preserved, but there won't be any links to the original workbook. When the Convert Text to table box appears, just click OK (no need to make any changes).Īs if by magic, the Excel table will now be formatted as a Table within Word, fitting into the normal Word margins, and breaking across pages as you would expect of a normal Word table. Now convert this selected area to a Table, as follows: select OUTSIDE the area that you have just pasted do not start or end your selection inside what was the Excel data).Ĥ. Select a range starting just before the beginning of the range just pasted, ending just after the end of the range (i.e. The pasted range will be much too big for the page, however this is the trick to make it fit (all the rest is done in Word):ģ. This is the same as paste Special/HTML Format. This allows me to copy Excel information into a Word table ending up in native Word format so it looks as good as the text in the rest of the document (but no links I am afraid):Ģ.
#PASTE CELLS AND PICTURE EXCEL FOR MAC TRIAL#
I came across this by dint of trial and error the other day. WHAT IS HAPPENING TO THIS STUPID DOCUMENT?!?!!!!!? I'm losing my mind. When I print the same thing straight from Excel, it looks fine. It views in Word with black "censor" bars through the title of the spreadsheet, and prints from Word looking fuzzy. I have gotten to the point where I can copy them as pictures and they work wonderfully, except for one of them. Nothing is different about the three documents. I made them all the same number of rows and columns, same size of rows and columns, font, etc. There are three different spreadsheets that need to be copied onto three separate pages within a Word doc. Like I said, I can do it six different ways in regular MS Word for Windows, but when I do it on Word 2004 for Mac, everything gets messed up. The spreadsheet created in Word is a funky size, and when you try to make it the correct size, it stretches the words. Well you can try use a menu Insert | Object, choose Ms excel Worksheet,and then you copy your excel data into that sheet, it's more easy like that Thanks in advance for your gracious advice!! I am very frustrated and after two days of this, I'm ready to pull out my hair.
#PASTE CELLS AND PICTURE EXCEL FOR MAC MAC#
I don't have the information she wants done, so I improvise with my own to test it out, and it always seems to work, but when I go into her office with her Mac and the information to be used, it NEVER WORKS!!!!! I have MS on my computer, so when I try these things out, they work. Please help me! I've tried regular copy/paste, but when I try and make it fit on one page, I only have so much room to adjust the size. I'm doing this for my boss, and every time we size it to fit, it ends up looking like (in her words exactly) "a cake that has fallen in on itself.short and fat" (stretching of the words and figures, even when using the corner instead of the sides). I can get it to fit to one page by copying as a picture or paste special but, as far as I can tell, there is no way to size it so that the quality is intact. I have looked on other forums at tons of other people's threads and tried everything.
I am trying to paste a spreadsheet from Excel into a Word document, but it needs to fit on ONE page. I am having trouble with the copy/paste function between Excel and Word.
0 kommentar(er)
