How to change the format of all pictures in a PowerPoint 2010 presentation

microsoft-powerpoint-2010

How do I change the format of all of the pictures in a PowerPoint 2010 presentation? I know how to change the format of one picture, but there are over 40 pictures in the deck and I do not want to have to change each one manually.

The change I want to make is simple: I want to add a border to each picture. How the border is added or what it looks like doesn't matter much. Right now I am right-clicking on the picture and clicking on Format Picture/Glow and Soft Edges and adding a 5pt Glow with a transparency of 0.

Best Answer

This little macro will do the job for you:

Sub AddPictureBorders()
' Before running this, apply the style you want to one picture
' then use the formatting paintbrush to pick up the formatting
' This will apply the formatting to each picture.
Dim oSh As Shape
Dim oSl As Slide

For Each oSl In ActivePresentation.Slides
    For Each oSh In oSl.Shapes
        With oSh
            ' ignoring linked pictures, OLE objects
            ' and such
            If .Type = msoPicture Then
                .Apply
            End If
        End With
    Next
Next

End Sub

Related Solutions

How to disable keyboard shortcuts in a Powerpoint 2010 slideshow

I think the "Browsed at a kiosk (full screen)" option would work.

office.microsoft.com says

Setting up a slide show to run at a kiosk allows you to control whether mouse clicks anywhere on the screen advance the slide. For example, if you want the slide show to be viewed at a specific pace, set automatic timings and then set the slide show to run at a kiosk. To give users additional control, you can add navigation, such as hyperlinks or action buttons, to your slides.
On the Slide Show menu, click Set Up Show.
Under Show type, click Browsed at a kiosk (full screen).
Note If you set up a slide show to run at a kiosk, remember to also add automatic timings or navigation hyperlinks or action buttons. Otherwise, the slide show will show only the first slide.

I'm pretty sure it also works in Powerpoint 2007 and 2010 (even though they aren't mentioned on that page).

Excel – Link Excel spreadsheet into PowerPoint presentation

If you are allowed to download and install the standard (and free) Microsoft product "Power Query", you can. More information about the use of Power Query can be found here. It is available from Office 2010 and up. It provides you with a lot of tools to select and merge data from different sources.

In your case, do the following:

Create a new Excel workbook.
Using Power Query, load the first action list to your Excel sheet .
Use "Append" to append the other action lists to the resulting table. At the end, you should have a (dynamically linked) combined list of all your action lists.
Using Power Query you can delete and rearrange the columns, sort the data and set filters on the columns. I recommend that you do the selection, sorting and filtering here in the Power Query, because if you do this in the final table in Excel, you need to re-apply all those filters every time you update the table.
Save the workbook and close Excel.
Start Powerpoint and on the Insert tab on the Ribbon choose Object and select "Create from file" and select the newly created Excel workbook with the combined action lists.

If you need to update the data, open the Powerpoint presentation and open the Excel object en click on the Refresh button and your data is updated. That's just a few clicks to update all of the action lists (cool, right?!)

This solution works for Office 2010 and 2013.

Finally there are your requirements about spanning multiple sheets and saving a static copy. There is no out-of-the-box answer to that, but I'd like you to consider to do this:

Keep a "master" version of your Powerpoint with the reference to the Excel file in it (hint: make this file read-only).
Every week, update the data with a few clicks as described above.
Copy the Excel table (even if it is too big for one sheet) and paste it as a picture (Paste - Picture or Paste - Paste special... - Microsoft Office Graphic Object).
Now you can duplicate the entire PowerPoint slide with the picture on it and use the cropping tools (select the picture and choose on the Ribbon tab Picture - Format - Crop) to select the right items on each sheet.
You can reduce the size of the PowerPoint presentation by selecting a picture and go to the Ribbon: Picture - Compress Pictures and choosing the appropriate settings.
Finally the sheet with the original Excel data can be deleted from this week's version of the presentation.

It is not really automated, but it keeps a non-editable version of your data in the presentation and it fulfills all of your requirements. The advantage of this approach is that all of the work can be done from the Powerpoint presentation itself.

Best Answer

Related Solutions

How to disable keyboard shortcuts in a Powerpoint 2010 slideshow

Excel – Link Excel spreadsheet into PowerPoint presentation

Related Question