We help IT Professionals succeed at work.

In Excel 2007, is there a way to place an image into a cell directly so it automatically resizes that the size of the cell?

360 Views
Last Modified: 2012-05-11
In Excel 2007, is there a way to place an image into a cell directly so it automatically resizes that the size of the cell?
Comment
Watch Question

Author

Commented:
I am aware you can manually set the width and hiegt of the image to the size of a cell, but is there a way to "kind of like" snap to a cell size, so if you make the cell larger, then the image will also enlarge?

Commented:
Not that I'm aware of.

You can insert an image and it will 'float' across the cells.

What context are you hoping to insert a picture?  Are you creating a form and want to insert a letterhead or such?

Commented:
in the image properties you can select "move and size with cell"  I think thats about the best you can get.  It will shrink with the cell but I dont think you can make it stretch beyonds its original size if you make the cell larger
SFWMD_IT: In the cell 'No' but as Plantwiz mentioned you can cover the relevant Cell/Cells. You can also increase or decrease the size of the picture beyond it's original size but you will have to take care of it's "lock Aspect Ratio"

Sid
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
TracyVBA Developer
CERTIFIED EXPERT

Commented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.