+ Reply to Thread
Results 1 to 2 of 2

locking images inside a cell

  1. #1
    Registered User
    Join Date
    11-28-2012
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007
    Posts
    48

    locking images inside a cell

    I have a long list of data, they only sensible way to view it is by sorting by the clients name. In each row i have inserted an image which is photo of the product.
    But when i sort the data the images or not getting sorted and the image and the products are being mismatched, is there a way to lock an image inside a cell so that when i hide or sort a row even the image should get hidden?

    Please Help

  2. #2
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: locking images inside a cell

    Go to the properties of the picture and set "Move and size with cells".
    See example: Pictures.xlsx
    Regards
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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