Photos in Excel

Occasional Visitor

I have a large collection of photos in Excel BUT when I insert row to add more phots the text moves down but the photos associated with that text do not move. I can't individually set the MOVE properties for each photo - is there a global way of ensuring that phots move with text.

My old excel allowed this automatically but Excel 365 doesn't

 

4 Replies

Hi @Kezza0065,

 

You need to add a new note to the cell

Yea_So_0-1625374458494.png

Hover your mouse over the border of the note and right click it

Yea_So_1-1625374530424.png

 

Then you will select format comment and a dialog box pops up, select colors and lines, then click on the drop down arrow of the Fill color and select fill effects

Yea_So_3-1625374697569.png

 

another dialog box will pop up, select the picture tab and select the picture

Yea_So_4-1625374903682.png

this dialog box will popup:

Yea_So_5-1625374992516.png

you can then select the picture you want to attach to that cell so when you insert a cell above it your picture will move with the cell.

Yea_So_0-1625375704925.png

 

 

cheers

@Kezza0065 , are you sure that you are selecting the correct row before inserting  row above?

Note the different behaviour of Excel as you insert row in below example. In case you select red row, then the image will not move with the sample text. In case you select green row, then image will move with the sample text. The key is that the top of the selected row should be above the top of the picture as indicated by arrows.

 

amit_bhola_0-1625422611452.png

 

@Kezza0065 

That's bit strange since in that part Excel 365 (if we speak about desktop version) has the same behavior as previous versions.

You may check and change Move property for all pictures at once such way

Home->Find & Select -> Go To Special -> Select Objects. All pictures will be selected, right click on any one and Format Object. Here properties could be changed for all pictures.

 

Firmly anchor the image in the row
Right mouse button -> Format graphic -> Properties -> Tick "depending on cell position and size" should help


Hope the information can help you

Wish you a nice day.
Nikolino
I know I don't know anything (Socrates)