Part of table not visible in MS Office 2007 Landscape Mode Initiator des Themas: Maria Dimitrova
|
Maria Dimitrova Bulgarien Local time: 21:53 Mitglied (2011) Englisch > Bulgarisch + ...
Hi, I have been struggling with some bug in MS Office and I though that maybe someone may help me work around this problem. I had to translate several tables in excel (financial statements), but the client wants them pasted in Word afterwards, because they have to be a certified translation and so the translation must be in word to be able to put a header. Since the tables are too wide, I changed the Page setup option in word to Landscape. However, when I p... See more Hi, I have been struggling with some bug in MS Office and I though that maybe someone may help me work around this problem. I had to translate several tables in excel (financial statements), but the client wants them pasted in Word afterwards, because they have to be a certified translation and so the translation must be in word to be able to put a header. Since the tables are too wide, I changed the Page setup option in word to Landscape. However, when I paste the excel table, the only visible part of it is the one that would fit into a Portrait page. Can anyone help me with info what settings should I change in order to be able to paste those tables properly? Thank you in advance. ▲ Collapse | | |
Tony M Frankreich Local time: 20:53 Mitglied Französisch > Englisch + ... SITE LOCALIZER Similar problem in Word XP | Apr 18, 2013 |
I have experienced a similar problem in the earlier Word XP; I found that once I had pasted the too-wide table, even changing the page layout to 'landscape' didn't bring back the missing part of the table. Part of the solution seemed to be to set the page layout to landscape BEFORE pasting; however, even then, some tables are just too wide for the paper size. I found that by switching to 'Normal' view instead of the 'Page layout' view that one 'normally' uses (!), I was able in effe... See more I have experienced a similar problem in the earlier Word XP; I found that once I had pasted the too-wide table, even changing the page layout to 'landscape' didn't bring back the missing part of the table. Part of the solution seemed to be to set the page layout to landscape BEFORE pasting; however, even then, some tables are just too wide for the paper size. I found that by switching to 'Normal' view instead of the 'Page layout' view that one 'normally' uses (!), I was able in effect to have an 'infinitely wide' page, and so my table was visible, albeit by scrolling across to see it all; or of course, reducing the % zoom to reveal it all (but at that point, it is usually too small to be legible). I don't know quite how all this works in W 2007, but I suspect the latter solution may well be what you need. ▲ Collapse | | |
Maria Dimitrova Bulgarien Local time: 21:53 Mitglied (2011) Englisch > Bulgarisch + ... THEMENSTARTER Still doesn't work | Apr 18, 2013 |
Thanks Tony, I tried what you said - changing the page setup before pasting and then switching to normal view, but the problem persists. I don't know, maybe I will have to draw tables manually and paste the translation(( | | |
felicij Local time: 20:53 Deutsch > Slowenisch + ... You might try | Apr 18, 2013 |
and adapt the table layout to fit the window. Simply select the whole table (+ in upper left corner), right click on it, select Autofit and then Autofit to Contents or Autofit to Window. It works on every table for me... | |
|
|
Maria Dimitrova Bulgarien Local time: 21:53 Mitglied (2011) Englisch > Bulgarisch + ... THEMENSTARTER I already tried that | Apr 18, 2013 |
Yes, I tried that, but it still fits within the space that would be for a portrait setup and some tables are really wide, so it turns out that the column names appear one letter over the other to fit. | | |
felicij Local time: 20:53 Deutsch > Slowenisch + ... well in that case | Apr 18, 2013 |
I don't think you can do anything else but to reduce the font size. | | |
Alan Douglas (X) Frankreich Local time: 20:53 A possible work-around: | Apr 18, 2013 |
Change column widths in Excel document(s) so that the full width of the table fits onto an A4 sheet. Change margin sizes to minimum and orientation to horizontal to allow yourself as much space as possible on the page. Ensure that text cells are set to automatic multi-line (you may have to adjust line height if some of the text dissapears). Gradually reduce the width of text columns until the full width of the table is to the left of the vertical dotted line. An additional option wo... See more Change column widths in Excel document(s) so that the full width of the table fits onto an A4 sheet. Change margin sizes to minimum and orientation to horizontal to allow yourself as much space as possible on the page. Ensure that text cells are set to automatic multi-line (you may have to adjust line height if some of the text dissapears). Gradually reduce the width of text columns until the full width of the table is to the left of the vertical dotted line. An additional option would be to reduce the standard font size (9 pt) is still legible in table format. Check on the pre-print view that the full width appears on the page and that no text has been lost. Open a new Word document. Change margin sizes to minimum and orientation to horizontal. Now copy and paste in the Excel table. ▲ Collapse | | |
Rolf Keller Deutschland Local time: 20:53 Englisch > Deutsch There are 2 methods for inserting content from other sources | Apr 18, 2013 |
Maria Dimitrova wrote: I paste the excel table The very first question: HOW do you paste? Via the clipboard oder via Insert/Object/MS Excel Sheet/From file? (I'm not sure about the English menu descriptions in your Word.) | |
|
|
Maria Dimitrova Bulgarien Local time: 21:53 Mitglied (2011) Englisch > Bulgarisch + ... THEMENSTARTER Things turned out to be not that bad | Apr 18, 2013 |
Alan, felicij , thanks for your input, the problem is the excel tables are already 9 pt and some of them are so wide, that even reducing the font size to 6 pt will not make the table fit into a portrait orientation. Rolf , I tried simple Copy-paste, then I tried the Paste special option and selected "MS Excel object", still no difference. However I found a partial solution to the problem, I printed several pages of the ones that do not look properly and a... See more Alan, felicij , thanks for your input, the problem is the excel tables are already 9 pt and some of them are so wide, that even reducing the font size to 6 pt will not make the table fit into a portrait orientation. Rolf , I tried simple Copy-paste, then I tried the Paste special option and selected "MS Excel object", still no difference. However I found a partial solution to the problem, I printed several pages of the ones that do not look properly and actually the entire table was printed on the sheet of paper, even though in word it seems "eaten". Probably this is some bug in the "View" options. It's a pity I didn't try this earlier... Thanks everyone for your input! ▲ Collapse | | |
Tina Vonhof (X) Kanada Local time: 12:53 Niederländisch > Englisch + ...
Maria Dimitrova wrote: Alan, felicij , thanks for your input, the problem is the excel tables are already 9 pt and some of them are so wide, that even reducing the font size to 6 pt will not make the table fit into a portrait orientation. I think you should have both documents in landscape (horizontal) orientation. | | |
Germaine Kanada Local time: 14:53 Englisch > Französisch + ... Go to the table properties | Apr 18, 2013 |
This is how I do it, once I copied-pasted (Ctrl-C, Alt-Tab, Ctrl-V) the table in Word: 1. Click anywhere in the table. Right-click and select « Table properties… ». 2. Under the Table tab, check “Preferred Width”; for “Measure in”, select “Percent”, enter 100% and click ok. The table will instantly fit between the margins of the page. Then you may adjust the font and if necessary, column sizes. | | |
Alex Lago Spanien Local time: 20:53 Englisch > Spanisch + ... Why not use Excel? | Apr 19, 2013 |
If the only reason you want it in word is because you need a header why don't you just simply put a header into the Excel file? | | |