Grey cell borders

Question

When I use 'none' for cell fill and copy and paste into powerpoint, the grey lines around the cells are showing. How can I get rid of them?

Answer 1

Hi, I think I figured it out! in Excel 2007, under view then show/hide  gridlines. When I copied and pasted into Powerpoint with the default (show gridlines) they showed up. I unclicked the box and the gridlines disappeared and then when I copied and pasted into Powerpoint they were gone and objects can show through. Thanks for your help (key word was gridlines, Toronto :-)) Nice to know the support is there when you need it...

Answer 2

ok try this,

again highlight the range to be copied, right click on the mouse, cell format,fill,Patern style,choose the first one which is blank,ok, now you shouldn;t see any line in your range

copy now to powerpoint, when you paste you still will see the lines click anywhere in the powerpoint presentation and the lines will dissapear

Answer 3

This may be a printer/options setting in Excel. By default excel copies "As printed", and I suggest your excel printer settings have "print gridlines" selected.

Go into excel and check your settings and then copy and paste again.

Answer 4

Hi Thanks for reply but I am still getting grey lines when I paste special into Powerpoint. I have to use white but then it covers up a logo on master page. Any help will be appreciated!

Answer 5

Hi highlight the cells, right click on the mouse, format cells, border, None