Format Inserted Excel Table
in [Beginners]
|
Prev: Higlihting entire rows or lines?
Next: Single Label
From: Ron Rosenfeld on 15 Jan 2010 14:11 On Fri, 15 Jan 2010 09:32:40 -0600, "Suzanne S. Barnhill" <sbarnhill(a)mvps.org> 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
From: Suzanne S. Barnhill on 15 Jan 2010 20:00 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" <ronrosenfeld(a)nospam.org> wrote in message news:6af1l5pn9sok55iil8fvjk4rsl8dvkt7mp(a)4ax.com... > On Fri, 15 Jan 2010 09:32:40 -0600, "Suzanne S. Barnhill" > <sbarnhill(a)mvps.org> > 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
From: Ron Rosenfeld on 15 Jan 2010 21:18 On Fri, 15 Jan 2010 19:00:52 -0600, "Suzanne S. Barnhill" <sbarnhill(a)mvps.org> 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
From: Suzanne S. Barnhill on 15 Jan 2010 21:48 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" <ronrosenfeld(a)nospam.org> wrote in message news:g682l59811pqagohicdu7evppvf2a1mrlj(a)4ax.com... > On Fri, 15 Jan 2010 19:00:52 -0600, "Suzanne S. Barnhill" > <sbarnhill(a)mvps.org> > 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 >
From: Ron Rosenfeld on 15 Jan 2010 22:30
On Fri, 15 Jan 2010 20:48:07 -0600, "Suzanne S. Barnhill" <sbarnhill(a)mvps.org> 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 |