Тёмный

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

Annette Slager
Подписаться 528
Просмотров 19 тыс.
50% 1

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

Хобби

Опубликовано:

 

22 июн 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 45   
@sylviamoritz6589
@sylviamoritz6589 25 дней назад
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
@AnnetteSlager 23 дня назад
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
@behramcooper3691 Месяц назад
Never knew about this. Well, you learn something new every day. Thank you.
@AnnetteSlager
@AnnetteSlager 29 дней назад
Glad I could help!
@querrythis
@querrythis 2 месяца назад
A very useful solution to the cell insert option. I like...... thanks for sharing
@AnnetteSlager
@AnnetteSlager 2 месяца назад
You are welcome 😊
@dominicgentolia9259
@dominicgentolia9259 2 месяца назад
Thank you! I did it successfully. More power to you and God bless you.
@AnnetteSlager
@AnnetteSlager 2 месяца назад
Glad it helped!
@maxmanonutube12
@maxmanonutube12 Месяц назад
Thank you. Easy to understand and follow. This tip I will surely use in the future.
@AnnetteSlager
@AnnetteSlager Месяц назад
Glad it was helpful!
@klausnielsen1537
@klausnielsen1537 3 месяца назад
Great description! TY very much 😊
@AnnetteSlager
@AnnetteSlager 3 месяца назад
You are so welcome!
@klausnielsen1537
@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 😅
@InterstellarRanger
@InterstellarRanger 3 месяца назад
Simple and Genius - you solved my problem just like that... Thank you!!!
@AnnetteSlager
@AnnetteSlager 3 месяца назад
You are welcome
@creatiw
@creatiw 3 месяца назад
Amazing! 🤩
@AnnetteSlager
@AnnetteSlager 3 месяца назад
Thank you
@MitchieMitchie-wp5rz
@MitchieMitchie-wp5rz 4 месяца назад
of all the videos i've watched, yours is better. Hope this gets more than views.
@AnnetteSlager
@AnnetteSlager 4 месяца назад
Thank you so much for your support and kind words.
@schubertpeter79
@schubertpeter79 4 месяца назад
very good!
@AnnetteSlager
@AnnetteSlager 4 месяца назад
Thank you! Glad you enjoyed it.
@meadowfjordside2825
@meadowfjordside2825 Месяц назад
Brilliant. Just f'n brilliant. Thanks!
@AnnetteSlager
@AnnetteSlager Месяц назад
Glad you enjoyed it!
@KCRU_Bou
@KCRU_Bou 3 месяца назад
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
@AnnetteSlager 3 месяца назад
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.
@jamilanjum374
@jamilanjum374 14 дней назад
Nice one video, Madam are you tel me this function available on google excel sheet. If yes kindly creat a video or tell me on it, best regards from Pakistan
@AnnetteSlager
@AnnetteSlager 13 дней назад
Thanks for the comment. I am sorry, but this can't be done on google sheets.
@rohk9380
@rohk9380 26 дней назад
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
@AnnetteSlager 23 дня назад
I am not aware of anyway of doing that.
@kdunlap3289
@kdunlap3289 2 месяца назад
How can I store zip code barcodes in a mailing list... And use them in mailings.
@vellankis0415
@vellankis0415 5 месяцев назад
How do I insert a big image to a viewable size while using the Note option
@AnnetteSlager
@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.
@josephcarlat9414
@josephcarlat9414 7 дней назад
Ok I just tried every thing you said and I am not getting the same options you get when I right click with the four-arrow cursor. As a matter of fact just about everything is grayed out. I have a Mac I am thinking that is the reason. Noticed someone else had the same problem and they had a Mac as well. You didn't reply to their comment.
@AnnetteSlager
@AnnetteSlager 5 дней назад
I'm sorry. I do not have Excel on a Mac to test it.
@ZornaiMihaly
@ZornaiMihaly Месяц назад
But... How did you put the picture into the note?
@AnnetteSlager
@AnnetteSlager Месяц назад
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
@ChandanKumar-pr9us 2 месяца назад
My excel not sowing many options format comment after section
@ThomasAllenKNZ
@ThomasAllenKNZ 2 месяца назад
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
@ChandanKumar-pr9us 2 месяца назад
@@ThomasAllenKNZ nothing happening
@ThomasAllenKNZ
@ThomasAllenKNZ 2 месяца назад
@@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
@ChandanKumar-pr9us 2 месяца назад
@@ThomasAllenKNZ thanks to help
@conniemai66
@conniemai66 2 месяца назад
@@ChandanKumar-pr9us mine doesn't show those options either on the border - I use a Mac I wonder if that could be why
@shithead2666
@shithead2666 2 месяца назад
Very informative video. Will the size of the file too big to be attached in a email.
@AnnetteSlager
@AnnetteSlager 2 месяца назад
Most likely not. It depends on the size of your workbook and the size and resolution of your images.
Далее
Excel Pictures in Cells (Ultimate Guide 2024)
11:35
Просмотров 2,5 тыс.
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Adding Pictures and Backgrounds into Excel
8:16
Просмотров 178 тыс.
How to Insert Image in Excel Cell
4:41
Просмотров 27 тыс.
Hidden Formatting Tricks for Slicers
5:01
Просмотров 58 тыс.
World’s Deadliest Obstacle Course!
28:25
Просмотров 106 млн
World’s Deadliest Obstacle Course!
28:25
Просмотров 106 млн
Планы на лето😅
0:23
Просмотров 1,3 млн