G
Guest
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
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
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.
S
Steve Rindsberg
Matthew P said: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
PowerPoint's simply pasting in what Excel's put on the clipboard. It doesn't
have any control over that, but you can turn the grid off in Excel before you
copy/paste to solve the problem.
I don't know if you can turn the grid off by default in Excel, but that's how
you'd have to do it.
G
Guest
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
S
Steve Rindsberg
I was thinking more Tools, Options, View tab, remove checkmark from Gridlines.
G
Guest
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
G
Guest
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?
S
Steve Rindsberg
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
S
Steve Rindsberg
We are on office 97 - I don't know if this makes a difference.
It does. See my other reply to Glenna. She's right, I'm right and we're both
wrong. ;-)
You won't be able to manipulate pictures using PPT macros.
As far as making macros available to all, you'll need to create an add-in.
Create an ADD-IN with TOOLBARS that run macros
http://www.rdpslides.com/pptfaq/FAQ00031.htm
PowerPoint records only PowerPoint actions, and not all of them. It won't
record anything you do in Excel, and when your spreadsheet is active, you're
in Excel for all intents and purposes.
It does. See my other reply to Glenna. She's right, I'm right and we're both
wrong. ;-)
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).
You won't be able to manipulate pictures using PPT macros.
As far as making macros available to all, you'll need to create an add-in.
Create an ADD-IN with TOOLBARS that run macros
http://www.rdpslides.com/pptfaq/FAQ00031.htm
When I create the macro and run it the clear gridlines element from the
excel menu does not work?
PowerPoint records only PowerPoint actions, and not all of them. It won't
record anything you do in Excel, and when your spreadsheet is active, you're
in Excel for all intents and purposes.
PPTMagician 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.
Glenna
Steve Rindsberg said:I was thinking more Tools, Options, View tab, remove checkmark from Gridlines.
wrote:
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
:
G
Guest
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?
S
Steve Rindsberg
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: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.
wrote:
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
:
G
Guest
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.
S
Steve Rindsberg
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.
This might help: show him how to turn on the Tables and Borders toolbar.
Once it's on, it appears when you select a table (which is the default paste
format from Excel). There's a borders button that makes it a one-click deal to
assign borders.
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?
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.