Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.newusers
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.word.newusers
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.word.newusers
Terry Farrell Terry Farrell is offline
external usenet poster
 
Posts: 2,904
Default 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   Report Post  
Posted to microsoft.public.word.newusers
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.word.newusers
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default 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   Report Post  
Posted to microsoft.public.word.newusers
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.word.newusers
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default 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   Report Post  
Posted to microsoft.public.word.newusers
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.word.newusers
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default 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   Report Post  
Posted to microsoft.public.word.newusers
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.word.newusers
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
erase gridlines from inserted excel table in ms word DeanH Microsoft Word Help 1 March 7th 09 10:18 AM
How do you import an Excel table into Word without losing format? C. Van Dam Tables 1 August 29th 06 05:50 AM
How do I get Excel information inserted into Word Table cell? trchbrr Microsoft Word Help 5 April 19th 06 09:21 PM
How I convert an excel table to label format? Daniella Cardoso Mailmerge 2 March 20th 05 08:47 AM
WORD 2000 pages layout when EXCEL table inserted Quetzalcoatl Page Layout 0 January 4th 05 10:13 PM


All times are GMT +1. The time now is 07:48 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"