Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!
Subscribe for Free Excel tips & more!

Cant Resize Table Rows In Powerpoint

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

This may be a power point question - but hopefully you guys will still know (is there a powerpoint forum with people as knowledgeable as you guys are about excel??)

When I copy and paste some excel cells into powerpoint, I can resize the columns to the width I want but am having trouble resizing the rows. I can make them bigger, but it won't let me make them smaller. I know it has rules about wrapping, etc. but it is not even close to the right size (the rows are about 3 line worth, but there is only 1 line of text).

I can take a screen shot if that would help, but I bet someone knows exactly what I am talking about.

Any thoughts?



View Answers     

Similar Excel Tutorials

How to Resize Rows and Columns in Excel Quickly
Resizing rows and columns in Excel is an easy process. Simply left click in between the columns and drag the mouse ...
Quickly Resize Multiple Columns or Rows at Once in Excel
How to quickly resize multiple columns and rows at once in Excel.  This avoids having to individually resize rows ...
Prevent Images and Shapes from Resizing or Moving in Excel
How to stop Images and Shapes from resizing in Excel when you change the size of rows and columns. This will allow ...
Get a Table Look with Only the Formatting in Excel
How to get the nice formatting of a table without turning your data into an actual table. Formatting data as a tab ...

Helpful Excel Macros

Open a PowerPoint Presentation from Excel
- This free macro for Microsoft Excel allows you to open any PowerPoint presentation from excel. You can change the file
Open Microsoft PowerPoint from Excel
- This free macro will open the Microsoft PowerPoint program on your computer. You do need to have this program first. T
Delete Rows in Excel if Completely Empty
- This macro will delete only completely blank rows in an excel spreadsheet. It allows you to make a selection of rows, ru
Highlight Every Other Row in a Selection in Excel - Table Formatting
- This free Excel macro will highlight every other row in a selection of cells with a color that is specified within the m
Make Text to Uppercase
- This macro will change all text within the selected cells to uppercase. It works only on selected cells within Microsoft

Similar Topics

Hi there,

I have a standard template in PowerPoint (A4 sized) which I populate with a series of tables and charts generated in Excel. I tend to copy then paste special to create an excel linked object which is fine.

The problem is that when I paste the item PowerPoint tends to resize it automatically, depending on the size of the object in Excel (a small table might copy through at 100%, a larger graph at 33%). Now I can resize it manually in PowerPoint, however I'm doing this multiple times and would prefer it to paste the chart at 50% of the original size every time (this also ensures font sizes remain the same throughout the ppt doc).

This may seem like a wee bit of an odd question but a solution would make my life a lot easier! Thanks in advance.



I have a page in Excel that is a calendar with text and coloured box entries. I have tried everything to insert this Excel page into PowerPoint however whatever I try, I cannot make the full page appear in PowerPoint. I have tried linking, cutting and pasting, opening a new table in PowerPoint, altering the handles in PowerPoint, resizing the font etc. For whatever reason, I cannot alter the Excel page to fit into one landscape PowerPoint page. In Excel the page is fine to print as a single sheet or can be viewed on one page if shrunk.

Appreciate someone's help!



I hope this is the correct place for this question.

What I'm trying to do is create powerpoint presentations, each of which have the exact same charts and visual style, but different information fed into it. I'm not sure if this can be done using excel and powerpoint together. I don't want to have to put in each piece of information manually every time I create a powerpoint presentation.

I realize this may be more of a power point question, and if there is no place on this forum for a question like this I would like to ask the moderators to direct me to a forum that can answere it for me. I have been VERY impressed with this forum. My questions are answered very quickly and always very effectively. That's why I came here first. If anyone knows of a better forum for Powerpoint where I could get an answer in 30 min like I do here, let me know.

Thank you

I have code to produce a PowerPoint presentation from my Excel workbook. Everything works fine for all the charts etc. which are a fixed size but there is one table that will vary in size due to the number of rows. I want to be able to use the full width of the Powerpoint slide all of the time and, if there are more than, say, 20 rows I want the full height also to be used. This I can achieve OK by "stretching" the picture to fit but it looks awful when there are only a few rows of data as they are all stretched vertically.

What I want to be able to do is to make the picture a height relative to the number of rows, can anybody help, thanks.

Hi all. I have multi-page Excel Reports that I have to put into PowerPoint. I currently hide rows and paste by page and resize in PowerPoint. Does anyone know of a better way to do this? It's become quite time consuming.

I am attempting to paste an excel data table in a powerpoint slide but once
pasted, the data is cut off. If I double click and enter the excel data
table and resize the window from Powerpoint, the same data shown simply
stretches to the new size. I have tried numerous ways of pasting from the
excel sheet and it still acts the same. I tried a new workbook and was able
to resize correctly. But to recreate all of the data and formulas in a
different workbook would be difficult. Is there a setting or something in
excel that is not allowing me to resize this particular workbook?

Thanks ahead of time for your help!

Hi All,

Great site. Been using it for years.

I'm able to paste charts to Powerpoint (using info from another thread). My problem is that I don't want the embed Excel in the power point. Can someone show how to do the paste in an Enhanced Metafile format? Also, how would I paste tables too in the enhanced Metafile format? Thanks in advance for your support.

Here's the core instructions I'm using right now:


'Create a Microsoft PowerPoint session
Set ppt = CreateObject("powerpoint.application")
'Copy the charts
'Make PowerPoint visible
ppt.Visible = True
'Activate PowerPoint
AppActivate ppt.Name
'Open a new document in Microsoft PowerPoint for first iteration only
Set pres = ppt.Presentations.Add
'Add a slide
pres.Slides.Add 1, ppLayoutBlank

'Paste the chart


I'm looking for a way to automate copying Excel charts into Powerpoint. Optimally I'd like to write some code that I can customize to select various charts within my workbook and copy them to different slides in a Powerpoint file (paste special - enhanced metafile pic), and resize the pasted pic as desired. Is this possible in VBA? I tried a couple different ways of recording macros in both Excel and Powerpoint but no luck.

Any ideas?


I have seperate workbooks with 30, 31 and 28 tabs dated for each day of the month.

I need a macro or a code to do the following task.

COPY PROTECTED excel table(s) on daily basis as BITMAP IMAGE, PASTE the bitmap image to POWERPOINT slide and RESIZE to the size of the standard PP slide.

Details of the table is as follows:

I have table from A1:U55 and A56:U94. The second table from A56:U94 should get copied, pasted and resized only if there is data in CELL A58 AND/OR K58. If there is no data in these cells, then only table from A1:U55 must be copied, pasted and resized on the powerpoint slide.


Hi Guys,

I have recently got myself a new laptop 17" to replace my desktop but it does something really strange in microsoft software (excel and powerpoint).

When I copy and paste something or scrolling, parts of the screen just go white (blank). I have to re paste or scroll then every time I do anything to see the screen (screen of powerpoint window or excel window only).

Has this happened to anyone else? If so, what is it that I need to do to stop this from happening as its really irritating.

Any help would be appreciated.



Hi forum,

I'm using XL and PowerPoint 2007. I've been able to create charts in PowerPoint that are linked to a specific XL file that has all of the data for multiple PowerPoint charts.

My goal is to have this XL file as the only companion file a user needs to update so that any changes he/she makes here will automatically propagate to the PowerPoint file.

Unfortunately, my issue is that when I email the PowerPoint and XL documents together, the PowerPoint file will retain the link to the XL file in my specific hard drive and so, a new user has to go edit the links manually to point to the new XL file. I would rather the PowerPoint file not care where the XL was originally saved and instead, only look for the XL file in the same directory as the PowerPoint file.

Is there an easy way for this to be done automatically? Can this be done in VBA?

Thanks for any thoughts!

I am posting an Excel Chart into Powerpoint as a Picture (Enhanced Metafile). I want to resize it in Powerpoint, and for some reason when I go to FORMAT->PICTURE->SIZE, there are just blanks for Height, Width, for Scale and Size and Rotate.

Previously there were values for each of those fields and I was able to adjust the size of the pasted Excel Chart. Now that those fields are blank, I am unable to adjust the size of my chart with exact %'s. I can only drag it in the Powerpoint Slide Window which isn't as exact.

Do you know how to get the above mentioned fields in FORMAT->PICTURE->SIZE to show up again?

Thanks Much

Hi All,

I have searched a number of threads on here for populating PowerPoint presentations from Excel... however, they dont show me how to add content (text, tables, charts) from Excel into an EXISTING PowerPoint Presentation.

Basically, I have a PowerPoint template which I need to add Excel content to using VBA.

Another question is that could the PowerPoint template be embedded in the Excel workbook so that it is all self contained?

Thanks very much for your help.


I am trying to put together a automated presentation with powerpoint. Since most of my content come from a Excel wbk I wrote my macro in Excel editor vba.

I need to resize a bitmap.

the following code works when it is in the powerpoint vba editor but not from excel.

Please Login or Register  to view this content.

Would you know if I need to reference to powerpoint library?
or should I declare an object ?
I could not find a solution, suggestions are very welcome.


I have been asked to make Excel appear like a Powerpoint slideshow by using a macro.

Does anybody know a way of doing this? Does anybody know how powerpoint covers the whole screen when you click the slide show button?

I have a way of making it appear to be Powerpoint, but my way only works for certain screen resolutions, which is a pain because the finished version will be distributed to many users.

Any help is very much appreciated.

I currently have a power point slide presentation. when the user gets to the end of the presentation, he clicks on an excel icon to go to excel and enter data on userforms which are set to auto run. Everything works fine except one thing. . . when the first userform unloads and the second one comes up, it is buried behind the powerpoint presentation. The only way to get to it is to control-alt-delete and close power point. At this point, the rest of the userforms load and perform exactly as planned.

Is there any way for excel to close the powerpoint presentation that it was initiated from? Or do I have to try to figure out how to do it from power point vba? Alternately, is there any code I can put on my userforms to always keep them on top?

Any help would be immensely appreciated. This is (hopefully) my last hurdle to finish this big project and I'm at my wits end.


I it possible to copy and paste multiple worksheets with graph , text into powerpoint slides via a macro?

Example if I have 5 sheets in Excel with graphs and text. I have a powerpoint file with 5 slides. I would like to copy and paste into powerpoint slides. The macro should be smart to navigate to the slide and paste the worksheet. The format should be exactly the same.

I read that there is a software EZpaste. Has anyone heard of this software? If so is it worth working on writing a macro or is the EZpaste software worth purchasing?


Does anybody know where I could go to get some help with PowerPoint. It seems like an easy enough problem to solve, but I can't figure it out and it's driving me crazy.

Let me know if you know of any good forums to use.



So this is my problem. I want to copy and paste link my excel charts to PowerPoint as an embedded chart object so that when I update the charts, PowerPoint will update automatically. I have done this successfully however, I cannot get the charts to come out the correct size. I have put all of the charts as 4.5" x 6.0" in excel so they should work, but I still get differences where the side wall and floor are not equal in width compared to another chart (in PowerPoint).

Does anybody have an idea of how I could address this problem so that when it appears in PowerPoint, will look correct. I need this to look the same because it is for a presentation given to corporate executives at my work.

Thanks again for any info.

I have an Excel application that enables the user to export an Excel chart directly into PowerPoint. The macro to do this works fine provided PowerPoint wasn't already open.

I am trying to figure the code so when the Excel application opens - it automatically closes any open PowerPoint.ppt - if in fact there are any open PowerPoint.ppt.

Here's what I have so far but I'm getting errors

Sub Workbook_Open()
Dim PPApp as PowerPoint.Application
Set PPApp = PowerPoint.ActivePresentation

With PPApp
   .Saved = msoTrue
End with
End Sub

Can anyone point me in the right direction?

Thank you,


I have some data in excel in a table of 5 columns. I want to copy the 3 last columns and paste these into powerpoint. I can do that manually, but the problem is the data is longer than i can display in one powerpoint slide, its likely to span dozens. I dont want to have to manually paste a group of rows at a time for each slide.

I think what i need is a way to copy and paste, and for Powerpoint to work out how many slides it needs and span the table across multiple slides. There may be other solutions which would work too.
Any help is greatly appreciated.


Admittedly, this is more of a powerpoint question, but you folks in exceltip land are really really smart!

I've embedded an excel workbook in powerpoint in order to display a chart. Here's the problem:

Step1: i open the embedded excel workbook to modify the chart
Step2: after modifying, i close the embedded file to view the powerpoint slide again
Step3: After closing the excel chart, powerpoint automatically resizes and distorts the embedded chart image. I understand that i can go to Format --> Object --> Size to exactly repair the chart dimensions, however i shouldn't have to do that.

Does anyone know how to make powerpoint stop messing with my chart dimensions? I encounter the same problem sometimes with charts created in powerpoint as well.

Thanks for any tips/suggestions!


As we are automating manual process of copy and paste from xls to powerpoint using vba code, we notice that the powerpoint file (pptm) size is increased 6 fold.

The original power point file is in .pptx with a file size of 4MB. The file size for the powerpoint file created with the vba code is 6 times greater, about 25 MB.

The file needs to be sent as an attachment via e-mail and we want to know how to reduce the file size. We tried saving as a .pptx but the size did not change.

Any ideas?

Thanks for your help.

please tell me how to create a macro in power point for a table.

I try to change the font cell color for the highest and lowest no for each line

I use powerpoint 2003

I'll buy a pint for anyone who can help save me an endless amount of time copying and pasting excel charts ito powerpoint...the problem is

(1) When I copy and paste charts into powerpoint I originally went through the paste special, paste link function. However when I right click on the chart in powerpoint and "update links" the chart/graph goes absolutely massive across the whole slide - I then have to click on the slide and delete it....hence at the moment I'm copying and pasting in as a picture each time (which is hard work every month when you are doing 30+ graphs)

All I want to be able to do is set them up in powerpoint and just update links everymonth !

I have a number of charts per slide (between 1 and 6) not sure if this impacts - but they have to be there as this is the report format

i Will buy a pint for anyone who can help me solve this one !!

(2) As an aside what is the best way to get graphs into powerpoint from a seperate excel workbook ? Even when i copy in as pictures i still have to resize each and everyone of them once in powerpoint, are there any shortcuts to this?


I am attempting to copy several spreadsheet ranges to a powerpoint file using VBA. I've found some excellent help at Peltier Technical Services but I have one sticking point. I want to copy to an existing PowerPoint file, not a new one, and I need to select the slide for each paste operation. I don't want to insert new slides. All the Peltier samples paste to whatever happens to be the current slide in the PowerPoint file. How do I select particular slide(s) in the PowerPoint file from my Excel VBA code?