How do I change default picture size

S

submerj

I have a spreadsheet in which I insert lots of pictures. All thes
pictures need to be fairly small and the same size. How can I chang
the default picture size so I can insert them without resizing eac
picture, or at least have them appear much smaller than the curren
default(which is huge) so I don't have to scroll to get to a corner t
resize
 
B

bj

Unfortunately you can't. you will need to resize them

You can make a macro to do so fairly easily
paste the big picture and run
Sub smpic()
Selection.ShapeRange.LockAspectRatio = msoTrue
Selection.ShapeRange.Height = 172.5
End Sub

It will make the picture beabout 3 inches wide
 
Top