Microsoft Excel
--
Questions
--
Followers
Top Experts
Change the resolution of Excel table in powerpoint - jagged fonts: bad
I often will insert an Excel worksheet object into a PowerPoint slide, then copy my data into the worksheet, format it and use this to get fine control of a table in PowerPoint.
I know that when you right click you can either:
edit: which lets you modify what cells are displayed and do simple edits
open: which opens the worksheet in Excel and you can do lots of things
properties: which lets you control the size borders, etc.
BUT- when I close it, even if I use the Arial font, I get an image bitmap with jagged and badly kerned letters.
Is there a way to get this to be finer resolution? Or to use the excel engine to display the text? Or ...
What I want is a PowerPoint result that looks better, not fuzzy, not jagged and not badly kerned.
I know that when you right click you can either:
edit: which lets you modify what cells are displayed and do simple edits
open: which opens the worksheet in Excel and you can do lots of things
properties: which lets you control the size borders, etc.
BUT- when I close it, even if I use the Arial font, I get an image bitmap with jagged and badly kerned letters.
Is there a way to get this to be finer resolution? Or to use the excel engine to display the text? Or ...
What I want is a PowerPoint result that looks better, not fuzzy, not jagged and not badly kerned.
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Which version of Office are you using? 2007? 2003? something different?
Try right-clicking the sheet on the slide and choosing Format Object. Is it set to a proportionate size (e.g., 100% x 100%) on the Size tab? (If in 2007, use the dialog launcher on the Size group.)
Try right-clicking the sheet on the slide and choosing Format Object. Is it set to a proportionate size (e.g., 100% x 100%) on the Size tab? (If in 2007, use the dialog launcher on the Size group.)
Hello Echo S, I am sorry to have missed the notice of your reply.
I am using Office 2003 sp3. Your suggestion to look at the size tab of properties and make it some good multiple of 100% is a good thread to go down, not sure it is going to bear fruit, but I know that the jaggies are much worse when it auto-sets it to 99% or 97% (two popular automatic settings -- even when I set it by hand to 100%.
But so far this doesn't do it. -
What I am hoping that there is a way to do is to get the bitmap that gets created to either be a wmf, or at least be 300x300 rather than what seems to be something like 70 pixels/in.
I know that there is some underlying setting because others send me ppts that I make *much* worse when I edit the excel.
Any clues will be rewarded.
As I say, I was traveling and missed the activity.
/g
I am using Office 2003 sp3. Your suggestion to look at the size tab of properties and make it some good multiple of 100% is a good thread to go down, not sure it is going to bear fruit, but I know that the jaggies are much worse when it auto-sets it to 99% or 97% (two popular automatic settings -- even when I set it by hand to 100%.
But so far this doesn't do it. -
What I am hoping that there is a way to do is to get the bitmap that gets created to either be a wmf, or at least be 300x300 rather than what seems to be something like 70 pixels/in.
I know that there is some underlying setting because others send me ppts that I make *much* worse when I edit the excel.
Any clues will be rewarded.
As I say, I was traveling and missed the activity.
/g
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Hello Echo_S,
Thanks for answering so quickly!
I know that I can use the WMF option, but I share the presentations and need to keep the excel capability. So I need to paste the excel object. I have seen someplace that says that having a background color helps to cut down on the jaggies, I am going to look at that also.
There must however be a way to change the resolution of image that ppt saves to display the underlying object. Any clues or pointers?
/g
Thanks for answering so quickly!
I know that I can use the WMF option, but I share the presentations and need to keep the excel capability. So I need to paste the excel object. I have seen someplace that says that having a background color helps to cut down on the jaggies, I am going to look at that also.
There must however be a way to change the resolution of image that ppt saves to display the underlying object. Any clues or pointers?
/g






EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
The worksheet is not animated. I have heard the same. Good call.
In viewing other answers you have provided to others, I am collecting other things to try. (Becuase I am about to have to reboot for a MAC OS update, I wanted to get the suggestions that you made recored someplace stable ;-)
In http:/Software/Office_Productivity/Office_Suites/MS_Office/Powerpoint/Q_23973121.html you suggested:
Improve PowerPoint's GIF, BMP, PNG, JPG export resolution
http://www.pptfaq.com/FAQ00052.htm
I am going to try also going to try:
Consider disabling AutoLayout
If you have PowerPoint 2002 (XP) or higher, you may want to turn Automatic Layout off. Automatic layout can cause your text boxes, pictures and other content to change size unpredictably and can lead to other oddball side effects.
as described on http://www.pptfaq.com/FAQ00034.htm
I tried the - define a default printer suggested on: How to install a local printer driver:
http://www.pptfaq.com/FAQ00605.htm
I also have looked at: http://support.microsoft.com/default.aspx?scid=kb;en-us;827745&Product=ppt2003
In viewing other answers you have provided to others, I am collecting other things to try. (Becuase I am about to have to reboot for a MAC OS update, I wanted to get the suggestions that you made recored someplace stable ;-)
In http:/Software/Office_Productivity/Office_Suites/MS_Office/Powerpoint/Q_23973121.html you suggested:
Improve PowerPoint's GIF, BMP, PNG, JPG export resolution
http://www.pptfaq.com/FAQ00052.htm
I am going to try also going to try:
Consider disabling AutoLayout
If you have PowerPoint 2002 (XP) or higher, you may want to turn Automatic Layout off. Automatic layout can cause your text boxes, pictures and other content to change size unpredictably and can lead to other oddball side effects.
as described on http://www.pptfaq.com/FAQ00034.htm
I tried the - define a default printer suggested on: How to install a local printer driver:
http://www.pptfaq.com/FAQ00605.htm
I also have looked at: http://support.microsoft.com/default.aspx?scid=kb;en-us;827745&Product=ppt2003
So far, none of the techniques have done anything to the resolution.
I notice that when I right click on the embedded excel and select Format Object->Size
There is a Lock aspect ration, which is checked
Relative to original picture, checked
and Best scale for slide Show, which is greyed out, and so is the Resolution: which shows 640x480
Is there any way to effect the resolution on this menu?
I notice that when I right click on the embedded excel and select Format Object->Size
There is a Lock aspect ration, which is checked
Relative to original picture, checked
and Best scale for slide Show, which is greyed out, and so is the Resolution: which shows 640x480
Is there any way to effect the resolution on this menu?
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Thanks Echo_S
Are other other places I might look? the http://www.pptfaq.com/FAQ00605.htm type references are excellent, and the question has been open for a while. If I don't get any more hits before Friday, I will award the points to you for the pointers.
Thanks!
Are other other places I might look? the http://www.pptfaq.com/FAQ00605.htm type references are excellent, and the question has been open for a while. If I don't get any more hits before Friday, I will award the points to you for the pointers.
Thanks!

Get a FREE t-shirt when you ask your first question.
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Thanks for your help!
You're welcome. Good luck with it -- sorry I don't have a specific answer that works for you!
Microsoft Excel
--
Questions
--
Followers
Top Experts
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.