Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 26
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 762
Default 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   Report Post  
Posted to microsoft.public.excel.misc
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Distorted Excel chart fonts when copy/paste to Word or Powerpoint JJMB Charts and Charting in Excel 2 March 18th 06 06:43 PM
Copy a whole Word doc into Excel sheet & keep it all visible? Jackstri Excel Discussion (Misc queries) 1 February 16th 06 01:56 PM
Copy and paste Excel chart in Word -- font compresses ScooterGirl Charts and Charting in Excel 3 February 10th 06 03:25 AM
Print Excel charts in Word 2003 with fixed size Phil Charts and Charting in Excel 1 November 3rd 05 04:24 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM


All times are GMT +1. The time now is 11:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"