Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a data table with product images that I want to filter depending on who I send the spreadsheet to. The pictures are still visibly stacked on top of each other.

How do I set up my sheet so that when rows/products are hidden (via data filter), their corresponding pictures are also hidden?

share|improve this question
add comment

2 Answers

Change the Object Positioning property for each image first. On XL2007, you can do this by following these steps:

  1. Right-click an image and click Size and Properties.
  2. Go to the Properties tab.
  3. Select Move and Size with Cells.

enter image description here

I suggest recording a macro to quickly do this for all of the images in your spreadsheet.

Make sure each image is positioned to appear as if they are "inside" a cell.

Here's an example to demonstrate:

No active filters
enter image description here

Filtered by Name
enter image description here

share|improve this answer
    
Great thanks for your help –  Dean Jul 9 '12 at 14:09
add comment

Thanks. This was a very simple and effective way.

I would like to add on, that instead of using the macros, we can select the function Go To (Ctrl+ G), then select "Special", then select "Objects", and then click OK. This will simply select all the images in the spreadsheet. Maybe we didn't have this function in XL2007, but the newer versions definitely have it. Cheers!!

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.