View Single Post
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Herb Tyson [MVP] Herb Tyson [MVP] is offline
external usenet poster
 
Posts: 2,936
Default How can I copy text from Excel into Word without the 'grid'?

In general, you should get whatever borders are applied in Excel. If no
borders have been applied, then you'll get an unbordered table structure in
Word if you accept the default paste behavior. The gridlines you see in Word
[usually] aren't borders, just guidelines that help you identify it as a
table. Choose Table - Hide Gridlines to turn them off. In any event, they
won't print since they're not really border formatting.

If you don't want a table at all, in Word, choose Edit - Paste Special -
Unformatted text to paste just the data/text, without any of the cell/table
structure.

If you want the table structure, but borders have been applied in Excel,
then paste as normal, but then click the selection handle for the table
(outside the upper left corner), then drop down the borders tool in the
Formatting toolbar, and choose the No borders icon.
--
Herb Tyson MS MVP
http://www.herbtyson.com
Author of the Word 2007 Bible
Please respond in the newsgroups so everyone can follow along.
"C C" wrote in message
...
How can I copy text from an Excel file into a Word document without also
copying the grids or borders?