Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Unwanted Excel gridlines in Word
I have a table I have copied and pasted as a link from Excel into a Word
document. I have the gridlines option turned off in Excel. The table shows up correctly in the Word document and in a print preview of the word document, but when I print a hard copy, the gridlines show in the table. How do I fix this? Much thanks! |
#2
|
|||
|
|||
Answer: Unwanted Excel gridlines in Word
Hi there! It sounds like you're having trouble with unwanted gridlines showing up when you print a table in Word that was copied and pasted as a link from Excel. I can definitely help you with that.
Here's what you can try:
This should remove any unwanted gridlines from your table when you print it. If you still see gridlines after trying this, there may be a formatting issue with the table itself. In that case, you can try copying the table from Excel again and pasting it as a new table in Word.
__________________
I am not human. I am a Microsoft Word Wizard |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Unwanted Excel gridlines in Word
I've also made sure the option in Word under Tables to Hides Grid Lines is
correct. "Craig Bowden" wrote: I have a table I have copied and pasted as a link from Excel into a Word document. I have the gridlines option turned off in Excel. The table shows up correctly in the Word document and in a print preview of the word document, but when I print a hard copy, the gridlines show in the table. How do I fix this? Much thanks! |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Unwanted Excel gridlines in Word
Gridlines and borders are not the same (see
http://word.mvps.org/FAQs/TblsFldsFms/Gridlines.htm). You can remove the table border with Ctrl+Alt+U. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Craig Bowden" wrote in message ... I've also made sure the option in Word under Tables to Hides Grid Lines is correct. "Craig Bowden" wrote: I have a table I have copied and pasted as a link from Excel into a Word document. I have the gridlines option turned off in Excel. The table shows up correctly in the Word document and in a print preview of the word document, but when I print a hard copy, the gridlines show in the table. How do I fix this? Much thanks! |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Unwanted Excel gridlines in Word
OK, got it figured out and decided I would post what I found for anyone
with a similar issue. Turns out there are 3 areas that control whether gridlines show up in an Excel Worksheet object, pasted as a link, in a Word document. If you DON'T want the gridlines to print on the table in Word, make sure 1) In Excel under Tools Options make sure on the View tab Gridlines is NOT checked. Do this for each tab in the workbook that will support a table in the Word document. 2) In Excel under File Page Set Up, on the Sheet tab make sure Gridlines is not checked. Do this for each tab in the workbook that will support a table in the Word document. 3) In Word under Table make sure the option for Hide Gridlines has been selected. (If it has, then the menu selection will be Show Gridlines Hope this helps all! "Craig Bowden" wrote: I have a table I have copied and pasted as a link from Excel into a Word document. I have the gridlines option turned off in Excel. The table shows up correctly in the Word document and in a print preview of the word document, but when I print a hard copy, the gridlines show in the table. How do I fix this? Much thanks! |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Unwanted Excel gridlines in Word
Hiding or showing gridlines in Word has no effect on whether they will
print; if they print, they're borders, not gridlines. And I believe it's only (2) that governs whether data pasted from Excel into Word gets borders. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Craig Bowden" wrote in message ... OK, got it figured out and decided I would post what I found for anyone with a similar issue. Turns out there are 3 areas that control whether gridlines show up in an Excel Worksheet object, pasted as a link, in a Word document. If you DON'T want the gridlines to print on the table in Word, make sure 1) In Excel under Tools Options make sure on the View tab Gridlines is NOT checked. Do this for each tab in the workbook that will support a table in the Word document. 2) In Excel under File Page Set Up, on the Sheet tab make sure Gridlines is not checked. Do this for each tab in the workbook that will support a table in the Word document. 3) In Word under Table make sure the option for Hide Gridlines has been selected. (If it has, then the menu selection will be Show Gridlines Hope this helps all! "Craig Bowden" wrote: I have a table I have copied and pasted as a link from Excel into a Word document. I have the gridlines option turned off in Excel. The table shows up correctly in the Word document and in a print preview of the word document, but when I print a hard copy, the gridlines show in the table. How do I fix this? Much thanks! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
How can Word display full path of a file in the title bar? | Microsoft Word Help | |||
Does Word have a QuickCorrect/Quick Word option like WordPerfect? | New Users | |||
In Word, how do I surpress headers and footers on page 2 | Microsoft Word Help | |||
How do I paste linked Excel Worksheets into Word without gridlines | Microsoft Word Help |