Re: How do I paste into PowerPoint and match destination formatting?

[Echo S]

"joe" <j...@discussions.microsoft.com> wrote in message
news:29AA654D-F944-4AED...@microsoft.com...
> 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/

[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/

"joe" <j...@discussions.microsoft.com> wrote in message
news:39A97EA1-403C-4B30...@microsoft.com...
> 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.