+ Reply to Thread
Results 1 to 2 of 2

How to insert a picture in a cell

  1. #1
    Registered User
    Join Date
    02-16-2005
    Location
    Oklahoma City
    MS-Off Ver
    Office 365
    Posts
    56

    How to insert a picture in a cell

    I have an Excel 365 worksheet that is a directory of people in an organization. Each row represents one person. Column F needs to contain the picture of the appropriate person for each row. How can I include a picture inside a cell (e.g., F7) and have the height of that row automatically adjust to the height of the picture?

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: How to insert a picture in a cell

    You can not insert a picture into a cell.
    You can have the picture position along side a cell, but it will be an object on the worksheet.

    Depending on the quantity of pictures you could either do this manually or with VBA code. In order to use a code approach you would need to be able to identify which image to use for any given row.
    You could then loop through all the rows, determine location of the image, insert a picture object of the image, adjust the row height and position the picture object.

    There should be examples of this on the forum, but if you can not find any post back with more information and I'm sure we can provide more help.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Insert Picture in cell, click commanbutton to rename picture, lock cell and remove button
    By thecdnmole in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-28-2014, 10:05 PM
  2. Insert Picture To Cell in Col A with pic name in Col B
    By EBTI in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-07-2014, 07:57 AM
  3. How to insert a picture into a cell
    By VickiFletcher in forum Excel General
    Replies: 3
    Last Post: 04-28-2014, 10:29 AM
  4. VBA for Picture insert at particular worksheet range. Picture name derived from cell.
    By Douglas2013 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2013, 01:16 AM
  5. Insert picture when cell changes
    By Rookie_User in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-22-2006, 03:45 AM
  6. [SOLVED] how to insert picture to the cell?
    By Johney Salem in forum Excel General
    Replies: 2
    Last Post: 01-23-2006, 01:00 PM
  7. how can I insert a picture in a cell
    By yakmelk in forum Excel General
    Replies: 2
    Last Post: 11-03-2005, 04:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1