J
joe
How do I paste an Excel 2003 range into PowerPoint and have the pasted data
match destination (PowerPoint 2003) formatting?
match destination (PowerPoint 2003) formatting?
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.
E
Echo S
joe said:How do I paste an Excel 2003 range into PowerPoint and have the pasted
data
match destination (PowerPoint 2003) formatting?
Do any of the options under Edit|Paste Special work for you?
J
joe
No, unfortunately, all the options in the Edit ->Paste Special doesn't help.
Let's say I have 4 rows and 5 columns of data in a range in Excel. I select
the data in that range, copy, go to PowerPoint, select the same number of
rows and columns in a PowerPoint table, Paste Special as "Formatted text".
The result is that I do get the pasted data. However, the data format in
Excel is Arial 18 and right-aligned; whereas the pasted formatted text in
PowerPoint is Arial 28 and left-aligned eventhough the cells in table range
is set to be Arial 18 right-align before the pasting.
Let's say I have 4 rows and 5 columns of data in a range in Excel. I select
the data in that range, copy, go to PowerPoint, select the same number of
rows and columns in a PowerPoint table, Paste Special as "Formatted text".
The result is that I do get the pasted data. However, the data format in
Excel is Arial 18 and right-aligned; whereas the pasted formatted text in
PowerPoint is Arial 28 and left-aligned eventhough the cells in table range
is set to be Arial 18 right-align before the pasting.
Echo S said:joe said:How do I paste an Excel 2003 range into PowerPoint and have the pasted
data
match destination (PowerPoint 2003) formatting?
Do any of the options under Edit|Paste Special work for you?
--
Echo [MS PPT MVP]
http://www.echosvoice.com
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/
E
Echo S
Ah, yeah. I think the only thing that's going to work is to just paste the
Excel "table" itself. So you'd have to choose "Excel object" in Edit|Paste
Special. Or choose "Excel table" from the paste options icon thing that
appears right after you paste. To do this, you would not paste into the
table cells on the slide, you'd just paste directly on the slide (in other
words, don't select table cells before you paste).
But, I know where the table font settings come from. It's not
straightforward at all.
If you copy in Excel and select the table cells in PPT and choose Edit|Paste
Special|Formatted Text, here's where the settings come from:
Font Size = the next size down (in the font dropdown on the toolbar) from
the size set in the text placeholder on the slide master
Font Face = the font face used in the Excel cells
Font Color = the font color used in the Excel cells
Alignment = the alignment set on the text placeholder on the slide master
So, if you create an additional slide master with a placeholder that uses
Arial 20 pt and is right-aligned, and apply that slide master to your table
slides, you should get the results you want when you paste.
If you choose Edit|Paste Special|Unformatted Text, the table gets all its
stuff -- size, font face, color and alignment -- from the text placeholder
on the slide master. The size is the same as with formatted text -- it's the
next size down from the size in the text placeholder on the slide master.
--
Echo [MS PPT MVP]
http://www.echosvoice.com
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/
Excel "table" itself. So you'd have to choose "Excel object" in Edit|Paste
Special. Or choose "Excel table" from the paste options icon thing that
appears right after you paste. To do this, you would not paste into the
table cells on the slide, you'd just paste directly on the slide (in other
words, don't select table cells before you paste).
But, I know where the table font settings come from. It's not
straightforward at all.
If you copy in Excel and select the table cells in PPT and choose Edit|Paste
Special|Formatted Text, here's where the settings come from:
Font Size = the next size down (in the font dropdown on the toolbar) from
the size set in the text placeholder on the slide master
Font Face = the font face used in the Excel cells
Font Color = the font color used in the Excel cells
Alignment = the alignment set on the text placeholder on the slide master
So, if you create an additional slide master with a placeholder that uses
Arial 20 pt and is right-aligned, and apply that slide master to your table
slides, you should get the results you want when you paste.
If you choose Edit|Paste Special|Unformatted Text, the table gets all its
stuff -- size, font face, color and alignment -- from the text placeholder
on the slide master. The size is the same as with formatted text -- it's the
next size down from the size in the text placeholder on the slide master.
--
Echo [MS PPT MVP]
http://www.echosvoice.com
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/
joe said:No, unfortunately, all the options in the Edit ->Paste Special doesn't
help.
Let's say I have 4 rows and 5 columns of data in a range in Excel. I
select
the data in that range, copy, go to PowerPoint, select the same number of
rows and columns in a PowerPoint table, Paste Special as "Formatted text".
The result is that I do get the pasted data. However, the data format in
Excel is Arial 18 and right-aligned; whereas the pasted formatted text in
PowerPoint is Arial 28 and left-aligned eventhough the cells in table
range
is set to be Arial 18 right-align before the pasting.
Echo S said:joe said:How do I paste an Excel 2003 range into PowerPoint and have the pasted
data
match destination (PowerPoint 2003) formatting?
Do any of the options under Edit|Paste Special work for you?
--
Echo [MS PPT MVP]
http://www.echosvoice.com
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/