Format Inserted Excel Table


R

Ron Rosenfeld

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
 
Ad

Advertisements

R

Ron Rosenfeld

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
 
T

Terry Farrell

Either you have Gridlines enable (View ribbon) or View Boundaries enabled in
Word Options.
 
R

Ron Rosenfeld

Either you have Gridlines enable (View ribbon) or View Boundaries enabled in
Word Options.

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
 
S

Suzanne S. Barnhill

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
 
R

Ron Rosenfeld

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
 
Ad

Advertisements

S

Suzanne S. Barnhill

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
 
R

Ron Rosenfeld

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
 
S

Suzanne S. Barnhill

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
 
R

Ron Rosenfeld

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
 
Ad

Advertisements

S

Suzanne S. Barnhill

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top