Apply the same picture format to many images in Word or PowerPoint


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Here’s how to apply the same formatting, borders and picture styles to more than one picture or graphic in Word, PowerPoint or Excel.

Picture Format tools don’t have custom styles (Microsoft please note) only the in-built pre-sets.  If you want to apply the same formatting to different images or graphics you’re somewhat on your own.

Format Painter

Format Painter works for pictures and graphics too.  It’s possible to copy the formatting, borders etc from one image to another, just as you can with text.

  • Select the graphic with the formatting you want.
  • Click Home | Clipboard | Format Painter
  • Move the changed mouse pointer to the target image
  • Click on the second image and the formatting will be applied.

Format Picture Format Painter - Apply the same picture format to many images in Word or PowerPoint

The VBA option

It’s possible to make a VBA macro with the formatting settings to be applied to any selection. Unfortunately, it’s complicated.

Record Macro won’t record picture formatting steps which makes it difficult to get the right settings.

Dig into the Word Object model and recreate the settings in VBA form.  There are two base objects:

  • InlineShape Object – when the graphic is Inline with the text, in other words part of the text layer in a document.
  • Shape Object – all other graphic with text wrapping (square, tight, behind text etc.), i.e part of the drawing layer.

The document XML is little help. The settings defined in the bowels of a .docx or .pptx bear little relation to the VBA properties.

In short: there’s no simple way to copy some existing picture formatting settings into the VBA equivalent.  There should be, but there is not.

The big weakness in Excel’s Data from Picture

Get Office Picture Manager free!

Making pictures smaller – some more options.

Adding Footnotes to Pictures

Add the US Flag into Word, Excel or PowerPoint

 

subs profile e1563205311409 - Apply the same picture format to many images in Word or PowerPoint
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address