Ultimate Guide to Adding Pictures to Excel: No Cell Adjusting Needed

Рет қаралды 16,572

Күн бұрын

Learn the amazing unknown way to add pictures to Excel without the hassle of adjusting cells. Insert pictures into Notes. With this quick and easy method, you can hide and show pictures whenever you want, without taking up any cell space. Say goodbye to the impracticality of Excel's built-in image feature and embrace this more practical solution. Watch the tutorial and don't forget to subscribe for more Excel tips and tricks!.
Link to the video: Adding and Exploring Excel's Unknown Secret Camera Tool
• Use Excel Camera Tool ...
#exceladdpictures #ExcelTips #datavisualization
Don't forget to subscribe to our channel for more handy Excel tutorials!
Free content to those who Subscribe: professoroffice.com/contact
0:00 - Description of Problem with Current Method of Adding Pictures
0:49 - Demo of Method of Displaying Pictures
1:40 - Add Text to Images
2:55 - Create New Note with Picture
4:54 - Edit Note with Picture
6:13 - How to have Picture display without moving cursor over it.
6:38 - Hide Pictures
6:58 - Show All the Pictures at the Same Time
7:34 - Remove a Picture

Пікірлер: 40

@sylviamoritz6589 5 күн бұрын

I am thrilled to fiind this lesson. I work with large sets of data (trademark records) I can link each trademark image to its trademark registration numer. Question: Can these images be linked to an on-line data base? Does this process increase the file size? What happens when you email/send the spreadsheet to a client--do they lose the images and just get the red x in a square? this is brilliant and I am grateful for your time.

@AnnetteSlager 3 күн бұрын

The size depends upon the size and resolution of your images. The images stay with the file so if you send it to someone else they will also see the images in the notes. I don't believe that you can tie the images directly to a database within a note even if you tried to program it. You could load a database into a separate worksheet and then access them when you are inserting the picture into the note. Hope this helps.

@behramcooper3691 12 күн бұрын

Never knew about this. Well, you learn something new every day. Thank you.

@AnnetteSlager 9 күн бұрын

Glad I could help!

@maxmanonutube12 25 күн бұрын

Thank you. Easy to understand and follow. This tip I will surely use in the future.

@AnnetteSlager 25 күн бұрын

Glad it was helpful!

@dominicgentolia9259 Ай бұрын

Thank you! I did it successfully. More power to you and God bless you.

@AnnetteSlager Ай бұрын

Glad it helped!

@querrythis 2 ай бұрын

A very useful solution to the cell insert option. I like...... thanks for sharing

@AnnetteSlager 2 ай бұрын

You are welcome 😊

@meadowfjordside2825 Ай бұрын

Brilliant. Just f'n brilliant. Thanks!

@AnnetteSlager Ай бұрын

Glad you enjoyed it!

@InterstellarRanger 2 ай бұрын

Simple and Genius - you solved my problem just like that... Thank you!!!

@AnnetteSlager 2 ай бұрын

You are welcome

@klausnielsen1537 3 ай бұрын

Great description! TY very much 😊

@AnnetteSlager 3 ай бұрын

You are so welcome!

@klausnielsen1537 3 ай бұрын

Now I wish I knew how to make a macro do most of this except pick the picture. And save it outside any specific notebook so I can run it in any notebook. But I struggle to do that 😅

@creatiw 2 ай бұрын

Amazing! 🤩

@AnnetteSlager 2 ай бұрын

Thank you

@schubertpeter79 3 ай бұрын

very good!

@AnnetteSlager 3 ай бұрын

Thank you! Glad you enjoyed it.

@MitchieMitchie-wp5rz 4 ай бұрын

of all the videos i've watched, yours is better. Hope this gets more than views.

@AnnetteSlager 4 ай бұрын

Thank you so much for your support and kind words.

@KCRU_Bou 2 ай бұрын

This is great! Thank you :) Do you how you can rotate images when you insert them like this ? For some reason when I insert them they are always rotated the wrong way!

@AnnetteSlager 2 ай бұрын

I will try to resolve your issue. When you insert an image it always appears as the original is. You can of course change the size to whatever you want. What kind of image are you trying to insert? When you select the picture use one from the Bing Image Search and then let me know if that appeared correctly.

@kdunlap3289 Ай бұрын

How can I store zip code barcodes in a mailing list... And use them in mailings.

@rohk9380 6 күн бұрын

how can i add images for difrent names in bottom rows in single click? i means in one click can we select multiple images for difrent names in row..pls tell is there any method or macro,thanks

@AnnetteSlager 3 күн бұрын

I am not aware of anyway of doing that.

@vellankis0415 4 ай бұрын

How do I insert a big image to a viewable size while using the Note option

@AnnetteSlager 4 ай бұрын

You can place any size image in a note. You can use the size handles on the bottom right corner of the note to resize the image to whatever you want.

@ZornaiMihaly 16 күн бұрын

But... How did you put the picture into the note?

@AnnetteSlager 15 күн бұрын

You need to watch more of the video. The video explains all of that. It doesn't start with putting the picture in the note.

@ChandanKumar-pr9us Ай бұрын

My excel not sowing many options format comment after section

@ThomasAllenKNZ Ай бұрын

Right click on the border of the note rather than the body of the note and you'll see the other options. This one tripped me up too.

@ChandanKumar-pr9us Ай бұрын

@@ThomasAllenKNZ nothing happening

@ThomasAllenKNZ Ай бұрын

@@ChandanKumar-pr9us at 3:29 her cursor is like a '+', four arrows going out, instead of the text edit cursor. It changes to that when you mouse over the note's border. That's where you right click to get all 8 tabs in Format Comment instead of only the 1 "Font" tab.

@ChandanKumar-pr9us Ай бұрын

@@ThomasAllenKNZ thanks to help

@conniemai66 Ай бұрын

@@ChandanKumar-pr9us mine doesn't show those options either on the border - I use a Mac I wonder if that could be why