Filtering data in excel with embedded pictures
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?
microsoft-excel
edited Jul 10 '12 at 8:52
Ellesa
8,56422946
asked Jul 9 '12 at 9:31
DeanDean
16112
add a comment |
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?
microsoft-excel
edited Jul 10 '12 at 8:52
Ellesa
8,56422946
asked Jul 9 '12 at 9:31
DeanDean
16112
add a comment |
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?
microsoft-excel
edited Jul 10 '12 at 8:52
Ellesa
8,56422946
asked Jul 9 '12 at 9:31
DeanDean
16112
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?
microsoft-excel
microsoft-excel
edited Jul 10 '12 at 8:52
Ellesa
8,56422946
asked Jul 9 '12 at 9:31
DeanDean
16112
edited Jul 10 '12 at 8:52
Ellesa
8,56422946
asked Jul 9 '12 at 9:31
DeanDean
16112
edited Jul 10 '12 at 8:52
Ellesa
8,56422946
edited Jul 10 '12 at 8:52
Ellesa
8,56422946
edited Jul 10 '12 at 8:52
Ellesa
8,56422946
8,56422946
asked Jul 9 '12 at 9:31
DeanDean
16112
asked Jul 9 '12 at 9:31
DeanDean
16112
asked Jul 9 '12 at 9:31
DeanDean
16112
16112
add a comment |
add a comment |
4 Answers
4
active
oldest
votes
Change the Object Positioning property for each image first. On XL2007, you can do this by following these steps:
- Right-click an image and click Size and Properties.
- Go to the Properties tab.
- Select Move and Size with Cells.
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
Filtered by Name
answered Jul 9 '12 at 9:53
EllesaEllesa
8,56422946
Great thanks for your help
– Dean
Jul 9 '12 at 14:09
add a comment |
- 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.
edited Jul 14 '14 at 12:48
Jens Erat
12.6k114459
answered Jul 14 '14 at 11:54
RubenRuben
111
add a 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!!
answered Dec 8 '13 at 13:08
Rahul KhannaRahul Khanna
1
add a comment |
I had the same issue with Excel 2016 and used a combination of answers to solve this:
- Ctrl+G or F5
- Select Special, then 'Objects' and click 'OK'
- Right-click on one of the images and click Size and Properties
- Select 'Move and size with cells' from 'Properties' and close
- Done
HOWEVER ONLY filtering works, sorting doesn't work properly. I have three columns with images. If I sort the one in the middle A-Z, the right column will sort properly, but not the left one. The left one is either missing images or overlapping again.
answered Aug 27 '18 at 9:58
ahjussiahjussi
11
Hi and welcome to SU. There already is answer with the same solution. It is better to just upvote the existing answer instead of creating a duplicate.
– Vlastimil Ovčáčík
Aug 27 '18 at 11:03
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f446627%2ffiltering-data-in-excel-with-embedded-pictures%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
4 Answers
4
active
oldest
votes
4 Answers
4
active
oldest
votes
active
oldest
votes
active
oldest
votes
Change the Object Positioning property for each image first. On XL2007, you can do this by following these steps:
- Right-click an image and click Size and Properties.
- Go to the Properties tab.
- Select Move and Size with Cells.
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
Filtered by Name
answered Jul 9 '12 at 9:53
EllesaEllesa
8,56422946
Great thanks for your help
– Dean
Jul 9 '12 at 14:09
add a comment |
Change the Object Positioning property for each image first. On XL2007, you can do this by following these steps:
- Right-click an image and click Size and Properties.
- Go to the Properties tab.
- Select Move and Size with Cells.
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
Filtered by Name
answered Jul 9 '12 at 9:53
EllesaEllesa
8,56422946
Great thanks for your help
– Dean
Jul 9 '12 at 14:09
add a comment |
Change the Object Positioning property for each image first. On XL2007, you can do this by following these steps:
- Right-click an image and click Size and Properties.
- Go to the Properties tab.
- Select Move and Size with Cells.
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
Filtered by Name
answered Jul 9 '12 at 9:53
EllesaEllesa
8,56422946
Change the Object Positioning property for each image first. On XL2007, you can do this by following these steps:
- Right-click an image and click Size and Properties.
- Go to the Properties tab.
- Select Move and Size with Cells.
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
Filtered by Name
answered Jul 9 '12 at 9:53
EllesaEllesa
8,56422946
answered Jul 9 '12 at 9:53
EllesaEllesa
8,56422946
answered Jul 9 '12 at 9:53
EllesaEllesa
8,56422946
answered Jul 9 '12 at 9:53
EllesaEllesa
8,56422946
8,56422946
Great thanks for your help
– Dean
Jul 9 '12 at 14:09
add a comment |
Great thanks for your help
– Dean
Jul 9 '12 at 14:09
Great thanks for your help
– Dean
Jul 9 '12 at 14:09
Great thanks for your help
– Dean
Jul 9 '12 at 14:09
add a comment |
- 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.
edited Jul 14 '14 at 12:48
Jens Erat
12.6k114459
answered Jul 14 '14 at 11:54
RubenRuben
111
add a comment |
- 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.
edited Jul 14 '14 at 12:48
Jens Erat
12.6k114459
answered Jul 14 '14 at 11:54
RubenRuben
111
add a comment |
- 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.
edited Jul 14 '14 at 12:48
Jens Erat
12.6k114459
answered Jul 14 '14 at 11:54
RubenRuben
111
- 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.
edited Jul 14 '14 at 12:48
Jens Erat
12.6k114459
answered Jul 14 '14 at 11:54
RubenRuben
111
edited Jul 14 '14 at 12:48
Jens Erat
12.6k114459
edited Jul 14 '14 at 12:48
Jens Erat
12.6k114459
edited Jul 14 '14 at 12:48
Jens Erat
12.6k114459
12.6k114459
answered Jul 14 '14 at 11:54
RubenRuben
111
answered Jul 14 '14 at 11:54
RubenRuben
111
answered Jul 14 '14 at 11:54
RubenRuben
111
111
add a comment |
add a 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!!
answered Dec 8 '13 at 13:08
Rahul KhannaRahul Khanna
1
add a 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!!
answered Dec 8 '13 at 13:08
Rahul KhannaRahul Khanna
1
add a 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!!
answered Dec 8 '13 at 13:08
Rahul KhannaRahul Khanna
1
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!!
answered Dec 8 '13 at 13:08
Rahul KhannaRahul Khanna
1
answered Dec 8 '13 at 13:08
Rahul KhannaRahul Khanna
1
answered Dec 8 '13 at 13:08
Rahul KhannaRahul Khanna
1
answered Dec 8 '13 at 13:08
Rahul KhannaRahul Khanna
1
1
add a comment |
add a comment |
I had the same issue with Excel 2016 and used a combination of answers to solve this:
- Ctrl+G or F5
- Select Special, then 'Objects' and click 'OK'
- Right-click on one of the images and click Size and Properties
- Select 'Move and size with cells' from 'Properties' and close
- Done
HOWEVER ONLY filtering works, sorting doesn't work properly. I have three columns with images. If I sort the one in the middle A-Z, the right column will sort properly, but not the left one. The left one is either missing images or overlapping again.
answered Aug 27 '18 at 9:58
ahjussiahjussi
11
Hi and welcome to SU. There already is answer with the same solution. It is better to just upvote the existing answer instead of creating a duplicate.
– Vlastimil Ovčáčík
Aug 27 '18 at 11:03
add a comment |
I had the same issue with Excel 2016 and used a combination of answers to solve this:
- Ctrl+G or F5
- Select Special, then 'Objects' and click 'OK'
- Right-click on one of the images and click Size and Properties
- Select 'Move and size with cells' from 'Properties' and close
- Done
HOWEVER ONLY filtering works, sorting doesn't work properly. I have three columns with images. If I sort the one in the middle A-Z, the right column will sort properly, but not the left one. The left one is either missing images or overlapping again.
answered Aug 27 '18 at 9:58
ahjussiahjussi
11
Hi and welcome to SU. There already is answer with the same solution. It is better to just upvote the existing answer instead of creating a duplicate.
– Vlastimil Ovčáčík
Aug 27 '18 at 11:03
add a comment |
I had the same issue with Excel 2016 and used a combination of answers to solve this:
- Ctrl+G or F5
- Select Special, then 'Objects' and click 'OK'
- Right-click on one of the images and click Size and Properties
- Select 'Move and size with cells' from 'Properties' and close
- Done
HOWEVER ONLY filtering works, sorting doesn't work properly. I have three columns with images. If I sort the one in the middle A-Z, the right column will sort properly, but not the left one. The left one is either missing images or overlapping again.
answered Aug 27 '18 at 9:58
ahjussiahjussi
11
I had the same issue with Excel 2016 and used a combination of answers to solve this:
- Ctrl+G or F5
- Select Special, then 'Objects' and click 'OK'
- Right-click on one of the images and click Size and Properties
- Select 'Move and size with cells' from 'Properties' and close
- Done
HOWEVER ONLY filtering works, sorting doesn't work properly. I have three columns with images. If I sort the one in the middle A-Z, the right column will sort properly, but not the left one. The left one is either missing images or overlapping again.
answered Aug 27 '18 at 9:58
ahjussiahjussi
11
edited Aug 27 '18 at 10:04
answered Aug 27 '18 at 9:58
ahjussiahjussi
11
answered Aug 27 '18 at 9:58
ahjussiahjussi
11
answered Aug 27 '18 at 9:58
ahjussiahjussi
11
11
Hi and welcome to SU. There already is answer with the same solution. It is better to just upvote the existing answer instead of creating a duplicate.
– Vlastimil Ovčáčík
Aug 27 '18 at 11:03
add a comment |
Hi and welcome to SU. There already is answer with the same solution. It is better to just upvote the existing answer instead of creating a duplicate.
– Vlastimil Ovčáčík
Aug 27 '18 at 11:03
Hi and welcome to SU. There already is answer with the same solution. It is better to just upvote the existing answer instead of creating a duplicate.
– Vlastimil Ovčáčík
Aug 27 '18 at 11:03
Hi and welcome to SU. There already is answer with the same solution. It is better to just upvote the existing answer instead of creating a duplicate.
– Vlastimil Ovčáčík
Aug 27 '18 at 11:03
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f446627%2ffiltering-data-in-excel-with-embedded-pictures%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
