要批量设置图片的格式,只能采用宏的操作,下面是我帮你写好的宏代码,你将代码粘贴到Excel的新模块里,然后运行就行了(运行完宏你的当前表中的所有图片格式都会设置好的)
Sub set_picture()
For i = 1 To ActiveSheet.Shapes.Count
ActiveSheet.Shapes(i).Select
With Selection
.Placement = xlMoveAndSize
.PrintObject = True
End With
Next
End Sub