Resize many images and cells

%3CLINGO-SUB%20id%3D%22lingo-sub-1492402%22%20slang%3D%22en-US%22%3EResize%20many%20images%20and%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492402%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20create%20these%20excel%20files%20automatically%20is%20there%20a%20way%20to%20make%20the%20images%20and%20cells%20bigger%20automatically%3F%20Maybe%20a%20free%20addon%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22pictures%20too%20small%20and%20overlap.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201330i15DF693AF0DB4CC3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22pictures%20too%20small%20and%20overlap.PNG%22%20alt%3D%22pictures%20too%20small%20and%20overlap.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1492402%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1492425%22%20slang%3D%22en-US%22%3ERe%3A%20Resize%20many%20images%20and%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492425%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F711410%22%20target%3D%22_blank%22%3E%40sjm84%3C%2FA%3E%26nbsp%3B%26nbsp%3BYou%20can%20easily%20resize%20the%20cells%20by%20selecting%20all%20(click%20the%20triangle%20next%20to%20col%20A%20and%20above%20row%201)%20then%20either%20go%20to%20cells%20-%26gt%3B%20format%20-%26gt%3B%20autosize%20for%20rows%20and%20columns.%20or%20double%20click%20the%20line%20between%20any%202%20rows%20or%20cols.%20OR%20you%20can%20manually%20resize%20all%20but%20select%20all%20and%20drag%20the%20row%20height%20%2F%20col%20width%20(the%20line%20between%202%20row%20or%20col%20headers)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi All,

 

I create these excel files automatically is there a way to make the images and cells bigger automatically? Maybe a free addon?

 

pictures too small and overlap.PNG

1 Reply
Highlighted

@sjm84  You can easily resize the cells by selecting all (click the triangle next to col A and above row 1) then either go to cells -> format -> autosize for rows and columns. or double click the line between any 2 rows or cols. OR you can manually resize all but select all and drag the row height / col width (the line between 2 row or col headers)