inserting from excel

[Matthew P Smith]

when I insert from excel the cell grid lines are visable. how do I remove
these as the default when I insert with CTRL V

 

[PPTMagician]

In Excel: Format, Style, Modify, Borders, None
or if you only want to turn it off for your selected Cells:
Format, Cells, Border, None.

Mine's off by default on the Normal Style so I don't get any lines.

Glenna

 

[PPTMagician]

When you paste with a CTRL-V, Excel cells are inserted as a table and the
line characteristics come from the borders settings. Doesn't matter if
gridlines are turned on or not. If you Paste Special, then the gridlines
matter, but they don't show up until you edit the spreadsheet within the
presentation.

Glenna

 

[Matthew P Smith]

We are on office 97 - I don't know if this makes a difference.

I am thinking of creating a macro to paste and clear the gridlines as in the
past I must have done paste special picture. Can I create this and have it
available for any presentation (custom button in toolbar).

When I create the macro and run it the clear gridlines element from the
excel menu does not work?

 

[buyer]

In Office 2003, if you paste into Word you get the borders, if you paste into
Powerpoint you don't (unless the cells in Excel have borders). In Office
2000, it put in the borders no matter what.
We have a sales rep who's hot that he has to do extra steps. Are we
missing some setting in Powerpoint that will fix this?

 

[buyer]

Sorry -- he's mad that he no longer gets the borders. He wants us to
reinstall Office 2000 because of this, which won't happen.

In Office 2003, if you paste into Word you get the borders, if you paste into
Powerpoint you don't (unless the cells in Excel have borders). In Office
2000, it put in the borders no matter what.
We have a sales rep who's hot that he has to do extra steps. Are we
missing some setting in Powerpoint that will fix this?

I'm not clear on the problem; is the sales rep annoyed that he's not getting
borders in PPT 2003 or that he IS getting 'em in 2000?

When you paste with a CTRL-V, Excel cells are inserted as a table and the
line characteristics come from the borders settings. Doesn't matter if
gridlines are turned on or not. If you Paste Special, then the gridlines
matter, but they don't show up until you edit the spreadsheet within the
presentation.

Interesting; it depends on the version of Office you use.
Office 2000 and before, you get the grid lines
Office 2003 you don't.

Dunno about 2002 since I only have it on systems with older and/or newer versions as
well and wouldn't think of trusting any OLE results there to be

Glenna

:


I was thinking more Tools, Options, View tab, remove checkmark from Gridlines.