So is there a way where I can insert a photo into the cell that is small, however, when hovering over it, it enlarges, but then goes back to being small again when the mouse is moved off the image? I am trying to create an image where I am able to insert images in a cell that have information on the image, but Don't want them to be supersize the entire time just when needed. Kinda like a pop up window.
Hi There. We've always followed these steps and it's always worked but since January 2022, if I delete or move rows, my pictures move all over the place, get squashed or deleted and even loose resolution so much that I can't recognise the picture anymore, please help
Great video! Quite helpful for what I am doing at the moment. I was wondering, is there a way to equate a cell to an image. So, for instance, if I create a timeline and I want to put an image over a certain area of the timeline, I would just be able to type "equals" in the cell I would want the image to appear in, select the cell the image is equated to, and automatically insert the image into the cell I've selected in the timeline. Hope what I've described makes sense. :-D Thanks in advance!
If Timeline was built in Google Slides you can go to slides add cell box and what took me a week to figure out but is so simple is Copy cell from sheets and past into slides, the attachment from sheet is automatic and will update dyanamically this tutorial is a bit on the anal side of life.
When I right click the picture all the options don’t appear on my drop down window. I get the cut paste and copy. Nothing else. How do I get to the other options??
This is close to what I need to do. I copy images from browser or PDF or whatever and paste it into Excel. I need to have BORDER LINE around the square when pasting it. Excel by default does not and so I have to manually go to Format Picture --> Line Color --> Solid Line and it works(except choosing this now makes the text image blurry but different problem). But it's a lot of clicks to get this done every time. Is there a macro or something simple that when I paste the image, it automatically inserts lines around the square box of image. I do lots of pasting images and this is too tedious! I want to do this because the images I copy/pasted onto Excel, the images look like part of another image. This is not defining the image from another materials near it.
Can you help me? I want to copy a timestamp (App) photo to excel. of course, there is info text in the photo (a jpg file). So I follow the step above but there is one problem that occurred when resizing the photo to put it in a small cell then saved the file, the text in the photo became unread or breaks.....how to resolve this?
How do we do vlookup for images. There are many number of unique ids matching with images respectively and there are other sheet with few ID I want to vlookup those images to new sheet. I saw many videos they have same trick which is lookup with naming. it works for single cell. it wont work for me.
It didn't work for me. I wish I understood why...and some pictures (photos) don't match the dimensions of the cell. And imagine 300 different photos different sizes. HELP
I am eternally grateful to you for this. It was actually an online interview question once.
I watched 5 videos and this one was the one with the answers i was searching for.👍🏼
Learning something new. Thanks.
We are very happy that we are contributive to easier using of MS Excel :)
Thanks a lot, I keep coming back to this video.
thank you sir for making this video
Really helpful! Huge thanks sir☺️
Thanks, sir, very informative video.
This was super helpful, thank you!
👋that was super helpful! I work with pivot tables and would love to insert a photo snip as a tutorial on how to create the pivot. Thank you!!!
Thanks
Great job
Thanks that was great
So is there a way where I can insert a photo into the cell that is small, however, when hovering over it, it enlarges, but then goes back to being small again when the mouse is moved off the image? I am trying to create an image where I am able to insert images in a cell that have information on the image, but Don't want them to be supersize the entire time just when needed. Kinda like a pop up window.
Thank you! Been splitting hairs on this for years
Very good👏🏻
Thank u po this help me alot ❤❤❤
Good work Mr. Frank, Thank you!!
Jayjagan, it's been a pleasure helping you :) Thank you for your feedback :)
wow.. great video!!
Great
Thank you
Thank you for this, so easy and helped a lot.
SUPERB, you're help me a lot
Thank you very much
Thank You so much
I have one question for it If user click on image can user should be able seen bigger format ?
Good one.
thank you
Thanks. It's helpful. 👍
Thanks♥
Awesome. Always wanted to know that
So grate sir
cool thankyou
When I hold on the ALT button on my Apple computer it duplicates the image for me. What button should I be pressing?
thnak u omg
tnnks prp
👋🏻that was super helpful! I work with pivot tables and would love to insert a photo snip as a tutorial on how to create the pivot. Thank you!!!
wonderfull
How do you do it on Mac?
Thankyou
Hi There. We've always followed these steps and it's always worked but since January 2022, if I delete or move rows, my pictures move all over the place, get squashed or deleted and even loose resolution so much that I can't recognise the picture anymore, please help
Great video! Quite helpful for what I am doing at the moment.
I was wondering, is there a way to equate a cell to an image. So, for instance, if I create a timeline and I want to put an image over a certain area of the timeline, I would just be able to type "equals" in the cell I would want the image to appear in, select the cell the image is equated to, and automatically insert the image into the cell I've selected in the timeline.
Hope what I've described makes sense. :-D Thanks in advance!
If Timeline was built in Google Slides you can go to slides add cell box and what took me a week to figure out but is so simple is Copy cell from sheets and past into slides, the attachment from sheet is automatic and will update dyanamically this tutorial is a bit on the anal side of life.
mazing !!!
When I right click the picture all the options don’t appear on my drop down window. I get the cut paste and copy. Nothing else. How do I get to the other options??
Is there a way to have multiple images stacked in a row in one cell
gOOd :)
Known about these tricks, but how does one do the hold Alt on Android phone?
This is close to what I need to do. I copy images from browser or PDF or whatever and paste it into Excel. I need to have BORDER LINE around the square when pasting it. Excel by default does not and so I have to manually go to Format Picture --> Line Color --> Solid Line and it works(except choosing this now makes the text image blurry but different problem). But it's a lot of clicks to get this done every time. Is there a macro or something simple that when I paste the image, it automatically inserts lines around the square box of image. I do lots of pasting images and this is too tedious!
I want to do this because the images I copy/pasted onto Excel, the images look like part of another image. This is not defining the image from another materials near it.
Thank you but I have one question, what if we have 300 pictures... how to move and size with the cells all of them, not one by one?
Click on one image, then hold control and A and all the images will be selected, right click and format then all as above
Is there a way to lock an image to a cell if you copy and paste the image?
THIS ^^^^^^ is the most important comment
Move and Size with Cells is not default. I think that get's a little bit there, but not "expected" wished for behavior.
i can only insert comment with picture if online mode, but when go online, telling to to update the latest version of internet explorer
What if the insert pictures command is not found in the ribbon?
Seems like this doesn't work with the online Office 365. That's sad. Is there something that can mimic this funcion in office 365?
how it can be done in office 365 excel? am not able to see the insert -->pictures , this one is missing in this version,
It's not working and I followed all the steps
Can you help me? I want to copy a timestamp (App) photo to excel. of course, there is info text in the photo (a jpg file). So I follow the step above but there is one problem that occurred when resizing the photo to put it in a small cell then saved the file, the text in the photo became unread or breaks.....how to resolve this?
start at 0:44
Try to imagine that you have a 50 picture that need to insert and then using your tricks. lol
But this image will change resolution, I want to keep 1000 * 1000 ?
Does not work with office 365 excel
How do we do vlookup for images. There are many number of unique ids matching with images respectively and there are other sheet with few ID I want to vlookup those images to new sheet.
I saw many videos they have same trick which is lookup with naming. it works for single cell. it wont work for me.
Not working for me. Image won't lock into cell.
It didn't work for me. I wish I understood why...and some pictures (photos) don't match the dimensions of the cell. And imagine 300 different photos different sizes. HELP
How to do in ipad
It would be great if it actually worked... But this method don't work!!!
Truly didn't help.
Quick and easy way... spend a THIRD of the video on nonsense!
Nope didn't work
totally waste no need to watch it
thank you sir for making this video
Thanks
thanks it was helpful
thank you
Angelito it's been a pleasure helping you :)