View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Yacbo Yacbo is offline
external usenet poster
 
Posts: 26
Default 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.