image Adding Type Issue

%3CLINGO-SUB%20id%3D%22lingo-sub-3186126%22%20slang%3D%22en-US%22%3Eimage%20Adding%20Type%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3186126%22%20slang%3D%22en-US%22%3E%3CP%3EHii%20There%20It's%20Mohit%20Here%2C%3C%2FP%3E%3CP%3EI%20want%20to%20Put%20an%20Image%20file%20behind%20The%20gridelines%20In%20Excel%20As%20Of%20My%20Choice%20Of%20Image%20Size%2FRatio%2CAnyone%20Here%20Can%20Help%20Me%20In%20This.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThankful%20If%20Issue%20resolved%3C%2FP%3E%3CP%3EMohit%20Tiwari%3C%2FP%3E%3CP%3E%2B91%209569408427%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3186126%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3187205%22%20slang%3D%22en-US%22%3ERe%3A%20image%20Adding%20Type%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3187205%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1311809%22%20target%3D%22_blank%22%3E%40beatwithmohit%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20would%20be%20the%20simplest%20solution%3C%2FP%3E%3CP%3EFit%20graphic%2Fphoto%20into%20cell%20while%20holding%20down%20ALT%20key.%3C%2FP%3E%3CP%3EThen%20right%20click%20on%20graphic%2Fphoto%3A%3C%2FP%3E%3CP%3Eformat%20graphic%3C%2FP%3E%3CP%3Eproperties%3C%2FP%3E%3CP%3Eoption%3C%2FP%3E%3CP%3EDependent%20on%20cell%20position%20and%20size.%3C%2FP%3E%3CP%3EOK.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20this%20method%20only%20works%20properly%20if%20the%20cell%20has%20the%20same%20aspect%20ratio%20as%20the%20image%20(almost%20impossible%20to%20agree%20on%20an%20aspect%20ratio%20with%20many%20different%20images).%3C%2FP%3E%3CP%3EIf%20this%20is%20not%20the%20case%2C%20the%20picture%20will%20be%20distorted%20when%20the%20cell%20size%20is%20changed.%3C%2FP%3E%3CP%3EBut%20at%20least%20now%20you%20know%20how%20it%20would%20go.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOf%20course%2C%20there%20is%20also%20the%20VBA%20method...%20but%20it%20depends%20on%20the%20Excel%20version%2C%20if%20not%20sometimes%20also%20on%20the%20operating%20system%20and%20storage%20medium.%3C%2FP%3E%3CP%3EHere%20is%20a%20%22taster%22%20example%20that%20I%20got%20from%20the%20internet%20a%20long%20time%20ago%20(unfortunately%20I%20can't%20remember%20exactly%20where%20it%20came%20from)%2C%20anyway%2C%20just%20have%20a%20look%2C%20maybe%20it%20will%20help%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFinally%2C%20please%20note%20that%20the%20cells%20are%20also%20subject%20to%20certain%20rules%20in%20Excel.%20If%20you%20enlarge%20a%20cell%20depending%20on%20the%20direction%2C%20the%20entire%20column%20or%20row%20changes%20or%20both%2C%20always%20after%20the%20largest%20object.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20information.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20Community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hii There It's Mohit Here,

I want to Put an Image file behind The gridelines In Excel As Of My Choice Of Image Size/Ratio,Anyone Here Can Help Me In This.

 

 

 

Thankful If Issue resolved

Mohit Tiwari

+91 9569408427

1 Reply

@beatwithmohit 

That would be the simplest solution

Fit graphic/photo into cell while holding down ALT key.

Then right click on graphic/photo:

format graphic

properties

option

Dependent on cell position and size.

OK.

 

However, this method only works properly if the cell has the same aspect ratio as the image (almost impossible to agree on an aspect ratio with many different images).

If this is not the case, the picture will be distorted when the cell size is changed.

But at least now you know how it would go.

 

Of course, there is also the VBA method... but it depends on the Excel version, if not sometimes also on the operating system and storage medium.

Here is a "taster" example that I got from the internet a long time ago (unfortunately I can't remember exactly where it came from), anyway, just have a look, maybe it will help you.

 

Finally, please note that the cells are also subject to certain rules in Excel. If you enlarge a cell depending on the direction, the entire column or row changes or both, always after the largest object.

 

Hope I was able to help you with this information.

 

NikolinoDE

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.