Changing bounds of excel file embedded in powerpoint

Question

When I embed an excel files into powerpoint, I'm having two issues.

• On some of the spreadsheets, empty columns are displayed on the right hand side of the powerpoint slide
• On other spreadsheets that are too large to fit, I can't adjust the bounds of what I'd like to be displayed on the slide. So, I couldn't choose a larger area to display of the excel spreadsheet and just size it down. It arbitrarily chooses where to cut off the excel spreadsheet on the slide.

Is there any way to adjust which part of the excel file is embedded?

Answer 1

Double click on the spreadsheet to "activate" it. Move your cursor to the black mark on the right side of the sheet, halfway between the top and bottom. When the cursor changes to a two-way horizontal arrow, click and hold, and drag the right edge to show as many columns as you want. There is a maximum amount of column space available- once you pass a certain limit it will not show any more columns.

Answer 2

Same problem here, I have a workaround for some simpler cases:

• go into Edit on the embedded Excel
• Select the region you want to show
• copy it (Ctrl+C)
• go into powerpoint again
• use paste special and paste as an excel object
• delete the old object

Ugly but works in simple cases (no multiple sheets and calculations).