宠爱何需多言!:
1、首先将图片插入到excel表格里面,然后将全部的照片都选中。2、选中之后,按Alt+F11组合键,将代码窗口调出来,并点击此窗口里面的插入-模块。3、接着在模块里面将下面的代码输进去:Subdq()DimshpAsShapeForEachshpInActiveSheet.Shapesshp.Left=(shp.TopLeftCell.Width-shp.Width)/2+shp.TopLeftCell.Leftshp.Top=(shp.TopLeftCell.Height-shp.Heigh....