M
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
these as the default when I insert with CTRL V
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
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
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
P
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
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
M
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?
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?
B
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?
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?
B
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.
reinstall Office 2000 because of this, which won't happen.
Steve Rindsberg said: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?
Steve Rindsberg said: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 bemeaningful. said:Glenna
:
I was thinking more Tools, Options, View tab, remove checkmark from Gridlines.