Skip to playerSkip to main content
  • 5 months ago
Learn how how to insert or add image in comment box in Excel. You'll also be answering can you insert a picture into a node in Excel? We short this tutorial is about how to insert a picture in Excel comment. Discover how to insert a picture into an Excel comment box, or insert a picture in a comment box in Excel.

These are the steps I'm showing on my video.

Insert Image In Comment Box
1) Right-click cell B2
2) New Note
3) Delete the existing content
4) Right-click on the note border
5) Format Comment...
6) Colors and Lines tab
7) In Color, select More Fill Effects
8) Picture tab
9) Select Picture
10) Lock picture aspect ratio
11) Insert
12) OK
13) OK


How to Insert or Add Image in Comment Box in Excel,Can you insert a picture into a note in Excel?,How to Insert a Picture in Excel Comment,Insert a picture into an Excel Comment Box,How To Insert A Picture In A Comment Or Note In Office 365,
Transcript
00:00if you want to create a pop-up picture like this as you roll over each cell this is how you do it
00:04select the cell where you want to create a pop-up from right click and then you select new note in
00:10here get rid of the existing tags like this and then right click on the border of the notes do
00:16not right click on the yellow area if you right click and go format comment you can see that it
00:21does not give you enough tabs you want to right click on the green border of the note and then
00:27go format comment and by doing so you can see you got slightly more tabs here click on colors and
00:32lines on colors you're going to do pull down here fill effect in here you're going to select pictures
00:39select pictures and if you get this error message is fine if you're working on your local drive which
00:45means your images are stored locally so i'm going to say work offline and navigate to the directory
00:51where your pictures are stored my pictures are stored here i'm going to select this picture
00:55and click on insert and after that i'm going to lock my picture aspect ratio because i'm going
01:01to adjust my height and width of my note so it doesn't look squashed click ok and click ok now
01:08adjust your height and width of your pop-up here like this and you are done
Comments

Recommended