New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

images won't stay where they are inserted

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

images won't stay where they are inserted

Postby bmallorca » Thu Dec 22, 2011 3:40 pm

Hello, I have been researching online about how to keep inserted images from moving around in excel. At this point only one out of 52 photos will not stay in place when resorting the data. The "trick" I last tried was to be sure that each photo was entirely inside the cell where it is meant to be. Why this one keeps moving is beyond me.

Each photo must stay with its own info, and I expect that the recipient will need to resort the spreadsheet to make it work for her.

Thanks for your help,
betty
a graphic designer who has always been mystified by excel!
  • 0

bmallorca
Rookie
 
Posts: 1
Joined: Dec 22, 2011
Reputation: 0

Re: images won't stay where they are inserted

Postby Sisyphus » Thu Dec 22, 2011 6:35 pm

Hi,
Did you check the properties of the pictures you insert?
Right-click on the picture in your Excel file. Select Format Picture, then select the Properties tab.
On this tab you have various choices to pick how you want the picture to behave, but the one that should interest you most would be the radio button "don't move or size with cells" which you should probably check.
I hope this helps.
Merry Christmas! :D
  • 0

Have a great day! :D

Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
Sisyphus
Former Moderator
 
Posts: 4454
Joined: Dec 7, 2011
Location: Shanghai
Reputation: 203
Excel Version: 2010


Return to General Excel Questions

Who is online

Users browsing this forum: Google [Bot] and 185 guests