How can you paste a spreadsheet from Excel without gridlines?


G

Guest

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
 
Ad

Advertisements

P

Peo Sjoblom

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
 
G

Guest

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
 
P

Peo Sjoblom

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
 
G

Guest

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
 
B

bobpom1

I have a similar question in Excel 2007/PowerPoint 2007.

I'm copying a mixed sheet (chart with separate numeric tables).

I want to copy the sheet in Excel exactly as laid out into Power Point, just
not the gridlines. I used to be able to do this in prior versions.

I copy, then Edit|Paste Special. I need to be able to resize in PowerPoint
too.

Thanks,

Bob Pomeroy
p.s. NOT a fan of the new Ribbon in 2007.
 
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