J
Jake
How do you copy data from an Excel spreadsheet (balance statement, profit and
loss etc.) to a Word document without the gridlines?
loss etc.) to a Word document without the gridlines?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
bxb7668
What exactly do you mean? If your spreadsheet does not have any
borders, after you paste you'll see gridlines on your screen, but they
don't print. If your spreadsheet does have borders on the cells,
those borders are also pasted and will print.
Brian
borders, after you paste you'll see gridlines on your screen, but they
don't print. If your spreadsheet does have borders on the cells,
those borders are also pasted and will print.
Brian
H
Harlan Grove
Jake said:How do you copy data from an Excel spreadsheet (balance statement, profit
and loss etc.) to a Word document without the gridlines?
First, this is the wrong newsgroup for Excel-specific questions. You'd be
much better off using microsoft.public.excel or microsoft.public.excel.misc
newsgroups.
If you're using copy/paste, then this depends on the format you're using to
paste into Word. If you paste as Picture, Picture (Enhanced Metafile) or
Unformatted Text, you won't get gridlines. If you paste in any of the other
formats including the default Rich Text format, you'll get gridlines.
Turning off gridlines in Excel doesn't stop Word from displaying borders
around each cell in the default Rich Text format.
Pasting as pictures would be the easiest way to avoid gridlines. If you must
paste as Rich Text, then easiest to use a macro in word to remove borders
from the most recently added table. Something like
Sub rmvbrdrs()
With ThisDocument.Tables(ThisDocument.Tables.Count)
.Borders(wdBorderLeft).LineStyle = wdLineStyleNone
.Borders(wdBorderRight).LineStyle = wdLineStyleNone
.Borders(wdBorderTop).LineStyle = wdLineStyleNone
.Borders(wdBorderBottom).LineStyle = wdLineStyleNone
.Borders(wdBorderHorizontal).LineStyle = wdLineStyleNone
.Borders(wdBorderVertical).LineStyle = wdLineStyleNone
.Borders(wdBorderDiagonalDown).LineStyle = wdLineStyleNone
.Borders(wdBorderDiagonalUp).LineStyle = wdLineStyleNone
.Borders.Shadow = False
End With
End Sub
J
Jake
Harlan,
Thank you for the response and help. I will try what you've suggested and I
am sure it will solve my problem.
Jake
Thank you for the response and help. I will try what you've suggested and I
am sure it will solve my problem.
Jake
J
Jake
Hi bxb7668,
Thans for steering me in the right direction. I appreciate the help and
directions. It shuld take care of the issue.
jake
Thans for steering me in the right direction. I appreciate the help and
directions. It shuld take care of the issue.
jake
H
Harlan Grove
....bxb7668 said:What exactly do you mean? If your spreadsheet does not have any borders,
after you paste you'll see gridlines on your screen, but they don't print.
If your spreadsheet does have borders on the cells, those borders are also
pasted and will print.
In Excel at least there's a difference between borders and gridlines.
Even if there were no *borders* on any cells in Excel, copying ranges of
cells in Excel and pasting (*not* Paste Special) into Word means Word uses
Formatted Text (RTF) (aka Rich Text) as the default format, and Word always
includes borders around all cells in rich text tables.