How can you paste a spreadsheet from Excel without gridlines? in Excel General Questions  
 |  Edit my Profile  |  Help
 
     
  
 
 
 
PhillyRon 8/9/2007 2:10 PM PST
  Question
  Hi guys,
I need to copy/paste some tables from Excel to my presentation in MS Word.
The gridlines disappear when I turned them off in the TOOLS/OPTIONS/VIEW
section, but they reappear when you paste them into MS Word What's the
secret?

PhillyRon
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Peo Sjoblom 8/9/2007 2:26 PM PST
   
  If you paste special as unformatted text then that's what you will get, you
can also paste using ctrl + v, select the table, do table>convert and select
convert table to text and select your delimiter



--
Regards,

Peo Sjoblom



"PhillyRon" <PhillyRon@discussions.microsoft.com> wrote in message
news:618E0ABF-1502-438F-95D2-8BAF9C369DF9@microsoft.com...
> Hi guys,
> I need to copy/paste some tables from Excel to my presentation in MS Word.
> The gridlines disappear when I turned them off in the TOOLS/OPTIONS/VIEW
> section, but they reappear when you paste them into MS Word What's the
> secret?
>
> PhillyRon


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
PhillyRon 8/9/2007 2:34 PM PST
   
  Peo,

The point is to preserve the table formatting that I worked hard to produce
in Excel, so converting everythng to text would defeat the purpose. Sorry.

Any other solutions out there?

PhillyRon

"Peo Sjoblom" wrote:

> If you paste special as unformatted text then that's what you will get, you
> can also paste using ctrl + v, select the table, do table>convert and select
> convert table to text and select your delimiter
>
>
>
> --
> Regards,
>
> Peo Sjoblom
>
>
>
> "PhillyRon" <PhillyRon@discussions.microsoft.com> wrote in message
> news:618E0ABF-1502-438F-95D2-8BAF9C369DF9@microsoft.com...
> > Hi guys,
> > I need to copy/paste some tables from Excel to my presentation in MS Word.
> > The gridlines disappear when I turned them off in the TOOLS/OPTIONS/VIEW
> > section, but they reappear when you paste them into MS Word What's the
> > secret?
> >
> > PhillyRon
>
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Peo Sjoblom 8/9/2007 2:54 PM PST
  Answer
  In Word (it is actually more of a Word than Excel question) select the table
(click the little square top left), do table>table properties, click borders
and shading, then click the none icon

However having said that, normally when you paste using ctrl + v you won't
get gridlines, just formatting and borders if they exist in the source
data. Also you can turn on and off gridlines from table>hide gridlines in
Word



--
Regards,

Peo Sjoblom




"PhillyRon" <PhillyRon@discussions.microsoft.com> wrote in message
news:79EA38A0-625B-4A19-A22D-55A6F611057C@microsoft.com...
> Peo,
>
> The point is to preserve the table formatting that I worked hard to
> produce
> in Excel, so converting everythng to text would defeat the purpose.
> Sorry.
>
> Any other solutions out there?
>
> PhillyRon
>
> "Peo Sjoblom" wrote:
>
>> If you paste special as unformatted text then that's what you will get,
>> you
>> can also paste using ctrl + v, select the table, do table>convert and
>> select
>> convert table to text and select your delimiter
>>
>>
>>
>> --
>> Regards,
>>
>> Peo Sjoblom
>>
>>
>>
>> "PhillyRon" <PhillyRon@discussions.microsoft.com> wrote in message
>> news:618E0ABF-1502-438F-95D2-8BAF9C369DF9@microsoft.com...
>> > Hi guys,
>> > I need to copy/paste some tables from Excel to my presentation in MS
>> > Word.
>> > The gridlines disappear when I turned them off in the
>> > TOOLS/OPTIONS/VIEW
>> > section, but they reappear when you paste them into MS Word What's the
>> > secret?
>> >
>> > PhillyRon
>>
>>
>>


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
PhillyRon 8/9/2007 3:14 PM PST
   
  Peo,

Oddly, initially using ctrl +v pasting doesn't remove the gridlines, but
your two suggestions to eliminate them within WORD work perfectly (after
which ctrl+v does work for the rest of the pasting). Thanks for ending my
frustration!

PhillyRon

"Peo Sjoblom" wrote:

> In Word (it is actually more of a Word than Excel question) select the table
> (click the little square top left), do table>table properties, click borders
> and shading, then click the none icon
>
> However having said that, normally when you paste using ctrl + v you won't
> get gridlines, just formatting and borders if they exist in the source
> data. Also you can turn on and off gridlines from table>hide gridlines in
> Word
>
>
>
> --
> Regards,
>
> Peo Sjoblom
>
>
>
>
> "PhillyRon" <PhillyRon@discussions.microsoft.com> wrote in message
> news:79EA38A0-625B-4A19-A22D-55A6F611057C@microsoft.com...
> > Peo,
> >
> > The point is to preserve the table formatting that I worked hard to
> > produce
> > in Excel, so converting everythng to text would defeat the purpose.
> > Sorry.
> >
> > Any other solutions out there?
> >
> > PhillyRon
> >
> > "Peo Sjoblom" wrote:
> >
> >> If you paste special as unformatted text then that's what you will get,
> >> you
> >> can also paste using ctrl + v, select the table, do table>convert and
> >> select
> >> convert table to text and select your delimiter
> >>
> >>
> >>
> >> --
> >> Regards,
> >>
> >> Peo Sjoblom
> >>
> >>
> >>
> >> "PhillyRon" <PhillyRon@discussions.microsoft.com> wrote in message
> >> news:618E0ABF-1502-438F-95D2-8BAF9C369DF9@microsoft.com...
> >> > Hi guys,
> >> > I need to copy/paste some tables from Excel to my presentation in MS
> >> > Word.
> >> > The gridlines disappear when I turned them off in the
> >> > TOOLS/OPTIONS/VIEW
> >> > section, but they reappear when you paste them into MS Word What's the
> >> > secret?
> >> >
> >> > PhillyRon
> >>
> >>
> >>
>
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies