Actuarial Outpost
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

Meet the Employees of DW Simpson
Patty Jacobsen Simpson, Bob Morand, Kristyn Sakelaris, Sean Loboda, KC Cho, Maureen Matous, Ellen Page
Aaron Benton, Becki Tobia, Kimberly Skora, Margit Vogele, Barclay Burns, Jason Blundy, Dan Karrow, Tom Troceen
Valorie Mulder, Marianne Westphal, Carol Lee, Jennifer Retford, Kieran Welsh-Phillips, Lindsey Nelson, Emily Paxton
Angie Wachholz, Derek Mulder, Julie Garwood, Caitlin Cunningham, David Benton, Dave Retford, Sarah Cleveland, Rhonda Glick
Genevieve Shannon, Meghan Bautista, Carol Datu, Barb Rave, Jesus Perez, Dan Kane, Chris Zdenek, Scott Simon, Kriss Wells

Thread Tools Display Modes
Old 02-06-2009, 04:22 PM
Phil's Avatar
Phil Phil is offline
Site Supporter
Site Supporter
Join Date: Sep 2001
Location: not on board the Enterprise
Posts: 5,667
Default Putting a picture "into" an Excel cell.

I am going to paste 10 very small .jpg files onto an Excel 2003 spreadsheet. Each picture is so small that it would easily fit into one Excel cell. I'd like to treat each picture the way Word allows you to - essentially pretend it is a big "character". Thus if the cell's Shrink To Fit or Wrap Text is on, I'd like the cell to resize to fit the picture.

If the above is not possible, then I'd like the picture to be absolutely associated with that cell, so that no matter what I do to the cell or to the Zoom of the spreadsheet, the picture is always displayed IN the cell, not stretching above or below it or anything weird like that.

What is the best way to accomplish this in Excel 2003? Thanks very much.

Reply With Quote
Old 02-07-2009, 07:06 PM
Phil's Avatar
Phil Phil is offline
Site Supporter
Site Supporter
Join Date: Sep 2001
Location: not on board the Enterprise
Posts: 5,667

I think I found the answer - apparantly the closest thing in Excel is to create a comment attached to the cell, delete the comment's text and set the background of the comment to be a picture. That's the only way to get a picture to be associated with a cell.
Reply With Quote
Old 02-08-2009, 10:00 PM
BassFreq's Avatar
BassFreq BassFreq is offline
Join Date: Jun 2003
Location: Chicago
Studying for all eternity
Favorite beer: Duff
Posts: 1,321

Would this work? Set the picture over the cell, double-click the pic, select Properties tab, then "Move and Size with Cells."
Res ipsa loquitur, sed quid in infernos dicet?
Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

All times are GMT -4. The time now is 01:54 AM.

Powered by vBulletin®
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.24165 seconds with 7 queries