Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
Format Inserted Excel Table
I have inserted an Excel spreadsheet as a table into a Word 2007 document
(saved as .docx) using the Insert/Table menu. I would like to remove the gridlines. How does one do this? In Excel, there is an option to not show these; there is also the possibility of formatting the cell borders to be white. But neither of these seems to work. I cannot locate an option to turn off gridlines. And when I try to set a cell border color to white, it returns to automatic. Thanks. --ron |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
Format Inserted Excel Table
On Thu, 14 Jan 2010 09:08:16 -0500, Ron Rosenfeld
wrote: I have inserted an Excel spreadsheet as a table into a Word 2007 document (saved as .docx) using the Insert/Table menu. I would like to remove the gridlines. How does one do this? In Excel, there is an option to not show these; there is also the possibility of formatting the cell borders to be white. But neither of these seems to work. I cannot locate an option to turn off gridlines. And when I try to set a cell border color to white, it returns to automatic. Thanks. --ron OK, never mind. Although the gridlines show on Print Preview, they do not show on the actual printout. --ron |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
Format Inserted Excel Table
Either you have Gridlines enable (View ribbon) or View Boundaries enabled in
Word Options. -- Terry Farrell - MSWord MVP "Ron Rosenfeld" wrote in message ... On Thu, 14 Jan 2010 09:08:16 -0500, Ron Rosenfeld wrote: I have inserted an Excel spreadsheet as a table into a Word 2007 document (saved as .docx) using the Insert/Table menu. I would like to remove the gridlines. How does one do this? In Excel, there is an option to not show these; there is also the possibility of formatting the cell borders to be white. But neither of these seems to work. I cannot locate an option to turn off gridlines. And when I try to set a cell border color to white, it returns to automatic. Thanks. --ron OK, never mind. Although the gridlines show on Print Preview, they do not show on the actual printout. --ron |
#4
Posted to microsoft.public.word.newusers
|
|||
|
|||
Format Inserted Excel Table
On Fri, 15 Jan 2010 09:46:17 -0000, "Terry Farrell"
wrote: Either you have Gridlines enable (View ribbon) or View Boundaries enabled in Word Options. -- Terry Farrell - MSWord MVP Terry, Thanks for the reply. On the Ribbon View menu, nothing is selected. (i.e. Gridlines is deselected). Under Word Options, I do not see a View Boundaries selection. Under Advanced/Show Document Content there is an option for "show text boundaries", but that is as close as I could find (and that is/was De-selected). As I wrote, the gridlines show on the various views of the document, and on the Print Preview, but not in the actual printout (or on a PDF file generated from the document using the Save As command). Any other suggestions for me to get a WYSIWYG view? --ron |
#5
Posted to microsoft.public.word.newusers
|
|||
|
|||
Format Inserted Excel Table
On the contextual Table Tools | Layout tab, turn off View Gridlines (in the
Table group at the far left). -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Ron Rosenfeld" wrote in message ... On Fri, 15 Jan 2010 09:46:17 -0000, "Terry Farrell" wrote: Either you have Gridlines enable (View ribbon) or View Boundaries enabled in Word Options. -- Terry Farrell - MSWord MVP Terry, Thanks for the reply. On the Ribbon View menu, nothing is selected. (i.e. Gridlines is deselected). Under Word Options, I do not see a View Boundaries selection. Under Advanced/Show Document Content there is an option for "show text boundaries", but that is as close as I could find (and that is/was De-selected). As I wrote, the gridlines show on the various views of the document, and on the Print Preview, but not in the actual printout (or on a PDF file generated from the document using the Save As command). Any other suggestions for me to get a WYSIWYG view? --ron |
#6
Posted to microsoft.public.word.newusers
|
|||
|
|||
Format Inserted Excel Table
On Fri, 15 Jan 2010 09:32:40 -0600, "Suzanne S. Barnhill"
wrote: On the contextual Table Tools | Layout tab, turn off View Gridlines (in the Table group at the far left). -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org Thank you for the suggestion. Although Table Tools/Layout tab appears when I select a normal "table", it does not appear when the table was created by using the Insert/Table/Excel*Spreadsheet method. --ron |
#7
Posted to microsoft.public.word.newusers
|
|||
|
|||
Format Inserted Excel Table
Insert a table temporarily and turn off the display of gridlines. This is an
environment setting that will affect all documents in Word. Then delete the table. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Ron Rosenfeld" wrote in message ... On Fri, 15 Jan 2010 09:32:40 -0600, "Suzanne S. Barnhill" wrote: On the contextual Table Tools | Layout tab, turn off View Gridlines (in the Table group at the far left). -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org Thank you for the suggestion. Although Table Tools/Layout tab appears when I select a normal "table", it does not appear when the table was created by using the Insert/Table/Excel Spreadsheet method. --ron |
#8
Posted to microsoft.public.word.newusers
|
|||
|
|||
Format Inserted Excel Table
On Fri, 15 Jan 2010 19:00:52 -0600, "Suzanne S. Barnhill"
wrote: Insert a table temporarily and turn off the display of gridlines. This is an environment setting that will affect all documents in Word. Then delete the table. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org I did that. Only the gridlines on this temporarily inserted table disappeared. The gridlines on the table that was inserted as an Excel Spreadsheet did not change. And a new table, inserted as an Excel spreadsheet subsequent to making that change, still showed gridlines. I also tried this on a new document. First inserting a (regular) table; removing the borders and setting to not display gridlines. Then inserting a table as an Excel worksheet. The latter showed gridlines; the former did not. --ron |
#9
Posted to microsoft.public.word.newusers
|
|||
|
|||
Format Inserted Excel Table
If you have inserted the Excel sheet as an OLE object, then it's Excel
you're dealing with, and you will have to disable the gridlines in Excel. Also, if you have gridlines displayed in Excel (or set to print in Excel, I forget which), you will automatically get borders on a table if you paste from Excel into Word as a Word table. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Ron Rosenfeld" wrote in message ... On Fri, 15 Jan 2010 19:00:52 -0600, "Suzanne S. Barnhill" wrote: Insert a table temporarily and turn off the display of gridlines. This is an environment setting that will affect all documents in Word. Then delete the table. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org I did that. Only the gridlines on this temporarily inserted table disappeared. The gridlines on the table that was inserted as an Excel Spreadsheet did not change. And a new table, inserted as an Excel spreadsheet subsequent to making that change, still showed gridlines. I also tried this on a new document. First inserting a (regular) table; removing the borders and setting to not display gridlines. Then inserting a table as an Excel worksheet. The latter showed gridlines; the former did not. --ron |
#10
Posted to microsoft.public.word.newusers
|
|||
|
|||
Format Inserted Excel Table
On Fri, 15 Jan 2010 20:48:07 -0600, "Suzanne S. Barnhill"
wrote: If you have inserted the Excel sheet as an OLE object, then it's Excel you're dealing with, and you will have to disable the gridlines in Excel. Also, if you have gridlines displayed in Excel (or set to print in Excel, I forget which), you will automatically get borders on a table if you paste from Excel into Word as a Word table. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org Ah, finally. I don't know if the Excel sheet was inserted "as an OLE object". I inserted it by selected the Insert tab on the Word Ribbon, then Table and Insert as Excel Spreadsheet. However, following your latest clue, when right clicked this "Excel Table" and then selected Worksheet*Object/Open (instead of Worksheet*Object/Edit), I was then able to get to an Excel Options menu which allowed me to make that change. Thanks. --ron |
#11
Posted to microsoft.public.word.newusers
|
|||
|
|||
Format Inserted Excel Table
Yes, when you insert an Excel spreadsheet in Word, you're actually creating
a piece of Excel in the Word document. If you just paste data in from Excel, it will be converted to a Word table. If you insert data from Excel as a link, then again you've got an OLE object. You can probably double-click on the Excel sheet in Word and get the full panoply of Excel toolbars (or Ribbon in this case). -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Ron Rosenfeld" wrote in message ... On Fri, 15 Jan 2010 20:48:07 -0600, "Suzanne S. Barnhill" wrote: If you have inserted the Excel sheet as an OLE object, then it's Excel you're dealing with, and you will have to disable the gridlines in Excel. Also, if you have gridlines displayed in Excel (or set to print in Excel, I forget which), you will automatically get borders on a table if you paste from Excel into Word as a Word table. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org Ah, finally. I don't know if the Excel sheet was inserted "as an OLE object". I inserted it by selected the Insert tab on the Word Ribbon, then Table and Insert as Excel Spreadsheet. However, following your latest clue, when right clicked this "Excel Table" and then selected Worksheet Object/Open (instead of Worksheet Object/Edit), I was then able to get to an Excel Options menu which allowed me to make that change. Thanks. --ron |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
erase gridlines from inserted excel table in ms word | Microsoft Word Help | |||
How do you import an Excel table into Word without losing format? | Tables | |||
How do I get Excel information inserted into Word Table cell? | Microsoft Word Help | |||
How I convert an excel table to label format? | Mailmerge | |||
WORD 2000 pages layout when EXCEL table inserted | Page Layout |