In Excel 2013, elements such as slicers can have their location set via the properties side-panel, but the properties panel for pictures does not have position fields:
How can I set and change the position of a picture in an Excel spreadsheet precisely by entering the desired distance from the top and left of the workbook? Alternatively, how can I see position of a picture so that I can adjust it precisely?
The reason for this need is that I want to place pictures in the same position in multiple workbooks.
I have found several questions and answers related to achieving this via Visual Basic or macros, but I would prefer to use the Excel UI.
Best Answer
As nixda described, the technique is to use the Format Picture ► Crop panel:
First, adjust the Left and Top values to move the picture's outline to the desired position - you'll see the Offset X and Offset Y values changing in the opposite direction, and the picture will remain where it was and will be cropped by the moved outline, but don't worry about that yet:
Now, change the Offset X and Offset Y values back to 0 to move the picture to the position of the outline: