How to select only pictures in activesheet

User avatar
StuartR
Administrator
Posts: 12577
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: How to select only pictures in activesheet

Post by StuartR »

HansV wrote:I did some testing in Excel 2010.
The dialog box, and behaviour, seem to be identical in Excel 2013
StuartR


User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: How to select only pictures in activesheet

Post by HansV »

Thanks, Rudi and Stuart, for confirming that Excel 2013 behaves the same as 2010.
Best wishes,
Hans

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: How to select only pictures in activesheet

Post by ABabeNChrist »

You guys are great, thank you; I’ll do more playing around and see what I can come up with.

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: How to select only pictures in activesheet

Post by Rudi »

HansV wrote:I did some testing in Excel 2010.
It turns out that the label "Apply only to this picture" is slightly misleading - it should actually be "Apply only to the selected picture(s)": if you have selected several pictures, and if the "Apply only to this picture" check box is ticked, all selected pictures will be compressed. If you clear the check box, all pictures in the entire workbook will be compressed.
Thank you for that discovery.
I have always thought it was to a single picture!

That is useful to know.
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.