cell auto-adjust to size of picture

Is there any way to have the cell automatically adjust to fit the size of the picture being added?
rtod2Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
rtod2Author Commented:
The suggestion you pointed to suggests to set "move and size with cells" from within the properties box for the picture.  I have done that but when I resize the cell, the picture doesn't resize.  That would clearly be a perfect option if it worked.  It doesn't appear to.  I am using Excel v2007.  What am I doing wrong.
0
 
MWGainesJRConnect With a Mentor Commented:
it works just fine for me.  It will only move with rows and columns that it fully covers.....If the last row that it "touches" is row 10, mvoe row 9. If column C is the column it touches, move column B
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
rtod2Author Commented:
I am trying to keep the pictures inside the grid lines for each cell, but still have it expand and contract as the cell size increases or decreases.
0
 
MWGainesJRConnect With a Mentor Commented:
you have to make sure that it completely covers the cell or else won't resize.....Just rezise the image to exactly the cell borders.
0
 
rtod2Author Commented:
Leaving out the grid lines would make this particular sheet very hard to read.
0
 
MWGainesJRConnect With a Mentor Commented:
I  don't understand.  I'm not saying remove the gridlines....I'm just saying resize A1 to the picture size and make sure the border of A1 is exactly the border of the picture....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.