Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General PowerPoint Questions / February 2006

Tip: Looking for answers? Try searching our database.

How do I paste into PowerPoint and match destination formatting?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
joe - 16 Feb 2006 19:16 GMT
How do I paste an Excel 2003 range into PowerPoint and have the pasted data
match destination (PowerPoint 2003) formatting?
Echo S - 16 Feb 2006 20:05 GMT
> 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?

Signature

Echo [MS PPT MVP]
http://www.echosvoice.com
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/

joe - 16 Feb 2006 21:26 GMT
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.

> > 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 S - 17 Feb 2006 02:52 GMT
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.

Signature

Echo [MS PPT MVP]
http://www.echosvoice.com
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/

> No, unfortunately, all the options in the Edit ->Paste Special doesn't
> help.
[quoted text clipped - 15 lines]
>>
>> Do any of the options under Edit|Paste Special work for you?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.