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

3 Answers 3

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
  • You can also use the Select button and select all the pictures by dragging a box around all pictures. Then right click properties etc., or
  • Select one picture and hit CTRL+A (select All), then right click properties etc.

Excel seems to understand that when selecting one picture and you press Select all (CTRL+A), you want to select all pictures.

share|improve this answer

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

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.