Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Excel chart to MS Word and print gridlines?
I have an Excel spreadsheet including printed gridlines. When I copy it into
an MS Word document the gridlines disappear. How can I move the chart to MS word and still print the gridlines? I am using Office 2003 editions of both MSWord and Excel. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Excel chart to MS Word and print gridlines?
Normally, it is the opposite question, "How do I copy WITHOUT the gridlines?"
Either way, when you copy and paste from Excel to Word, it is a good idea to use EditPaste Special and experiment with the options available until you get the desired result. Normally, if you choose the "Bitmap" option, the selected worksheet area will appear in Word as it does in Excel. Using one of the "Picture" options will typically omit the gridlines. A basic copy and paste seldom produces a desirable result. -- Y "Chris L 99" wrote: I have an Excel spreadsheet including printed gridlines. When I copy it into an MS Word document the gridlines disappear. How can I move the chart to MS word and still print the gridlines? I am using Office 2003 editions of both MSWord and Excel. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Excel chart to MS Word and print gridlines?
Thanks for the tip. I tried it, using the "Bitmap" option, and that works
fine. Appreciate your help. Now all I have to do is find out what "bitmap" means! Regards Chrisl 99 "Yacbo" wrote: Normally, it is the opposite question, "How do I copy WITHOUT the gridlines?" Either way, when you copy and paste from Excel to Word, it is a good idea to use EditPaste Special and experiment with the options available until you get the desired result. Normally, if you choose the "Bitmap" option, the selected worksheet area will appear in Word as it does in Excel. Using one of the "Picture" options will typically omit the gridlines. A basic copy and paste seldom produces a desirable result. -- Y "Chris L 99" wrote: I have an Excel spreadsheet including printed gridlines. When I copy it into an MS Word document the gridlines disappear. How can I move the chart to MS word and still print the gridlines? I am using Office 2003 editions of both MSWord and Excel. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Excel chart to MS Word and print gridlines?
Chris L 99 -
If it's a chart object on a worksheet, you could try: Select the chart by clicking just inside its outer border. Hold down the Shift key, and from the Edit menu, choose Copy Picture. Try some of those options, and then do the usual Paste into Word. - Mike http://www.mikemiddleton.com "Chris L 99" wrote in message ... I have an Excel spreadsheet including printed gridlines. When I copy it into an MS Word document the gridlines disappear. How can I move the chart to MS word and still print the gridlines? I am using Office 2003 editions of both MSWord and Excel. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Excel chart to MS Word and print gridlines?
In a nutshell, "bitmap" means "consumes alot of memory". Of course, you
could Google it and get a more technical answer, but trust me on this one. Since you have discovered a method you know will work in a crunch, do some more experimenting. Try selecting the Excel cells you wish to convey to Word, right click your mouse,Format CellsBorder and add some dark lines. Then select the cells, right click and choose Copy. Then go to Word and click EditPaste Special and choose one of the "Picture" options. Your new "dark" gridlines should appear and the associated graphic will consume much less of your memory resources. Fool around with these options until you get the proper mix-- it's different for every application and you just have to keep at it until you get what is right for you! But work at it from both ends- Excel and Word present options which can optimize the final appearance in your document. I wish you the best of luck- let me know if I can help further. -- Y "Chris L 99" wrote: Thanks for the tip. I tried it, using the "Bitmap" option, and that works fine. Appreciate your help. Now all I have to do is find out what "bitmap" means! Regards Chrisl 99 "Yacbo" wrote: Normally, it is the opposite question, "How do I copy WITHOUT the gridlines?" Either way, when you copy and paste from Excel to Word, it is a good idea to use EditPaste Special and experiment with the options available until you get the desired result. Normally, if you choose the "Bitmap" option, the selected worksheet area will appear in Word as it does in Excel. Using one of the "Picture" options will typically omit the gridlines. A basic copy and paste seldom produces a desirable result. -- Y "Chris L 99" wrote: I have an Excel spreadsheet including printed gridlines. When I copy it into an MS Word document the gridlines disappear. How can I move the chart to MS word and still print the gridlines? I am using Office 2003 editions of both MSWord and Excel. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Distorted Excel chart fonts when copy/paste to Word or Powerpoint | Charts and Charting in Excel | |||
Copy a whole Word doc into Excel sheet & keep it all visible? | Excel Discussion (Misc queries) | |||
Copy and paste Excel chart in Word -- font compresses | Charts and Charting in Excel | |||
Print Excel charts in Word 2003 with fixed size | Charts and Charting in Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel |