Expand a photo in a numbers cell

Not when it is clicked but you can paste an image into the background of a cell (double-click in the cell and then command-v to paste). It will then expand when you increase the size of the cell.

However, this is not an efficient setup for a lot of images. Numbers isn't really meant to be an image repository.

If you want to view images with a click then you can store them in Dropbox or another service that allows you to copy a link, and then paste that link into a Numbers cell. When you click the link in a cell the corresponding image will open. That can work quite well for lots of images.

SG

I don't know if this will be of any use for your needs but there are a few things you might be able to do.

If you create a table with only one cell (cell A1) and make that cell of a suitable size for viewing an image, you can copy the cell that has the image and paste it into this one-celled table for viewing.

You can access the full size picture in the cell tab of the sidebar on the right and do a few different things with it:

You can drag it from that little box to some blank place on the sheet and it will insert the full size image into your document, on top of everything else. You would have to delete it after looking at it. This may be the closest approximation to what you are requesting.

You can drag it from the box to a shape (a rectangle most likely) previously placed in your document and it will use it as a fill for the shape. It may require an extra step of sizing it to fit within the shape. Also, if you are not careful you may accidentally drop it onto the sheet, like described above, not into the shape.

If you have the Preview App icon in the dock, you can drag the image from that little box and drop it on the Preview icon to open the full size image in Preview.

Here's another approach, using a separate table to contain and display the image(s).

The larger table on the left (Table 1) contains five cells with the image displayed in each pasted into the cell as Image Fill (and space for four more) in Column A.

Column B contins a key number for each image (which could be a product name or item number)

Column C contains the formula shown below the table, which compares the value in 'this row' of column B the value in cell

A2 of Table 2, the smaller of the two tables shown.

Table 2 is a single column table with two rows: a header row, containing the label, Key, and a pop-up menu cell, A2 with a menu containing the key values matching those in column B of the larger table.

Note that Table 2 has the key value 5 displayed, and the cell to the right of that value on Table 1 is the only one in Column C containing TRUE, indicating a match with the key.

A Filter, shown in the side panel of the image below is applied to Table 1 to show only rows containing TRUE in Column C.

In use, columns B and C of Table 1 are hidden. and, with the filter active, only the header row and rows where the value in the hidden column B matches the value shown in A2 of Table 2 will be visible.

Cells in the example are kept small to fit easily into the space available here, but can be made larger in your document.

To avoid 'bounce' when changing images, ensure that the rows containing images are all the same height.

Regards,

Barry

EZEVANS wrote:

pop open a photo for a visual cue.

If you have an internet connection and a free Dropbox account that is exactly what will happen when you click a link to an image stored in Dropbox, as described above. Clicking the link pops open the image.

SG

Beautiful. That was neat.