Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
Embed an Excel Spreadsheet in Word Document
I have created a Gantt Chart with Excel. I would like to embed that
spreadsheet in Word for a report. I have used "Paste Special" -- "MS Excel Object" However, there is 2 problems 1) Part of the Excel Spreadsheet is not shown in Word (Even though I have chosen A3 as paper size for the Word Document). 2) Is it possible to paste in such a way that the gridlines are shown ? Your advice is sought. Peter |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
Embed an Excel Spreadsheet in Word Document
Embedded objects cannot span multiple pages so if the chart is larger than
the paper size then unfortunately you'll have to resize the chart to make it work. I'm not sure what you mean about "paste in such a way the gridlines are shown". If the gridlines are turned on for the Excel worksheet then they should display however they will not print unless in the Excel workbook, in Page Setup, you have Gridlines selected on the Layout tab. Is this what you were asking? Please post all follow-up questions to the newsgroup. Requests for assistance by email can not be acknowledged. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP Co-author of Word 2007 Inside Out: http://www.microsoft.com/MSPress/boo...x#AboutTheBook Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "Peter" wrote in message ... I have created a Gantt Chart with Excel. I would like to embed that spreadsheet in Word for a report. I have used "Paste Special" -- "MS Excel Object" However, there is 2 problems 1) Part of the Excel Spreadsheet is not shown in Word (Even though I have chosen A3 as paper size for the Word Document). 2) Is it possible to paste in such a way that the gridlines are shown ? Your advice is sought. Peter |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
Embed an Excel Spreadsheet in Word Document
Peter
I think that in Off 2007, in Excel you need to check the Print Gridlines option on the Page Layout tab: then when you copy into Word the WS Grids will come across formatted with viewable borders. -- Terry Farrell - MS Word MVP "Peter" wrote in message ... I have created a Gantt Chart with Excel. I would like to embed that spreadsheet in Word for a report. I have used "Paste Special" -- "MS Excel Object" However, there is 2 problems 1) Part of the Excel Spreadsheet is not shown in Word (Even though I have chosen A3 as paper size for the Word Document). 2) Is it possible to paste in such a way that the gridlines are shown ? Your advice is sought. Peter |
#4
Posted to microsoft.public.word.newusers
|
|||
|
|||
Embed an Excel Spreadsheet in Word Document
Dear Beth and Terry,
Many thanks for your advice. The Excel Spreadsheet is indeed larger than 1 page. In Excel, I can easily get it printed by changing the ratio. To resize the chart - Does it mean that to resize the chart in Excel so that it doesn't span multiple pages ? Re the second question, it is exactly as what Terry suggests, when I print with gridline, I get the gridline background with some of the lines filled (by me). It is what I want to show in the Word Document. I have tried Terry's suggestion, to set "Print Gridline" in Excel 2000 but when I paste special (embed Excel), the gridline is still not shown. Is there any suggestion. Regards, Peter "Beth Melton" wrote in message ... Embedded objects cannot span multiple pages so if the chart is larger than the paper size then unfortunately you'll have to resize the chart to make it work. I'm not sure what you mean about "paste in such a way the gridlines are shown". If the gridlines are turned on for the Excel worksheet then they should display however they will not print unless in the Excel workbook, in Page Setup, you have Gridlines selected on the Layout tab. Is this what you were asking? Please post all follow-up questions to the newsgroup. Requests for assistance by email can not be acknowledged. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP Co-author of Word 2007 Inside Out: http://www.microsoft.com/MSPress/boo...x#AboutTheBook Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "Peter" wrote in message ... I have created a Gantt Chart with Excel. I would like to embed that spreadsheet in Word for a report. I have used "Paste Special" -- "MS Excel Object" However, there is 2 problems 1) Part of the Excel Spreadsheet is not shown in Word (Even though I have chosen A3 as paper size for the Word Document). 2) Is it possible to paste in such a way that the gridlines are shown ? Your advice is sought. Peter |
#5
Posted to microsoft.public.word.newusers
|
|||
|
|||
Embed an Excel Spreadsheet in Word Document
Just a thought, then I'll butt out
Excel's gridlines are thin and gray, so in an embedded object they often aren't visible unless you increase your zoom setting to something over 100% - this can vary with display resolution. Sometimes _some_ gridlines display & others don't. Do the lines _print_ when you print the doc? Regards |:) Bob Jones [MVP] Office:Mac On 4/15/07 7:34 AM, in article , "Peter" wrote: I have tried Terry's suggestion, to set "Print Gridline" in Excel 2000 but when I paste special (embed Excel), the gridline is still not shown. Is there any suggestion. |
#6
Posted to microsoft.public.word.newusers
|
|||
|
|||
Embed an Excel Spreadsheet in Word Document
Yes, you also need to resize the chart so it doesn't span more than one page
in Word. For your gridlines, the printing options are not the same as viewing options. When you embed an Excel workbook, what you see in the Word document and Print Preview, is not the same as what you see when you actually print the document. If you want to see the gridlines in both the printed copy and document view, you need the gridlines turned on for printing, as Terry suggested, but for viewing in the Excel workbook in the Word document, go to Tools/Options/General and turn on Gridlines. Please post all follow-up questions to the newsgroup. Requests for assistance by email can not be acknowledged. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP Co-author of Word 2007 Inside Out: http://www.microsoft.com/MSPress/boo...x#AboutTheBook Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "Peter" wrote in message ... Dear Beth and Terry, Many thanks for your advice. The Excel Spreadsheet is indeed larger than 1 page. In Excel, I can easily get it printed by changing the ratio. To resize the chart - Does it mean that to resize the chart in Excel so that it doesn't span multiple pages ? Re the second question, it is exactly as what Terry suggests, when I print with gridline, I get the gridline background with some of the lines filled (by me). It is what I want to show in the Word Document. I have tried Terry's suggestion, to set "Print Gridline" in Excel 2000 but when I paste special (embed Excel), the gridline is still not shown. Is there any suggestion. Regards, Peter "Beth Melton" wrote in message ... Embedded objects cannot span multiple pages so if the chart is larger than the paper size then unfortunately you'll have to resize the chart to make it work. I'm not sure what you mean about "paste in such a way the gridlines are shown". If the gridlines are turned on for the Excel worksheet then they should display however they will not print unless in the Excel workbook, in Page Setup, you have Gridlines selected on the Layout tab. Is this what you were asking? Please post all follow-up questions to the newsgroup. Requests for assistance by email can not be acknowledged. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP Co-author of Word 2007 Inside Out: http://www.microsoft.com/MSPress/boo...x#AboutTheBook Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "Peter" wrote in message ... I have created a Gantt Chart with Excel. I would like to embed that spreadsheet in Word for a report. I have used "Paste Special" -- "MS Excel Object" However, there is 2 problems 1) Part of the Excel Spreadsheet is not shown in Word (Even though I have chosen A3 as paper size for the Word Document). 2) Is it possible to paste in such a way that the gridlines are shown ? Your advice is sought. Peter |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incerting Excel spreadsheet into a word document | Microsoft Word Help | |||
How do I convert a WORD document to an EXCEL spreadsheet? | Microsoft Word Help | |||
Excel Spreadsheet within a Word Document | Microsoft Word Help | |||
Word Document With Embedded Excel Spreadsheet | Microsoft Word Help | |||
excel spreadsheet to word document HOW? | Microsoft Word Help |