How to insert a “pop-out image thumbnail” into a cell in Numbers

graphicsnumbers

I have a Numbers document where I would like to insert images into each cell in one of the columns, in one of my data tables. The images are quite large, so I would like to insert the images as a thumbnail, and have them "pop out" when I click or mouse-over the image, so that I can see the full-size image. How can I accomplish this effect? Is this at all possible?

It was fairly simple to add an image to a cell via drag-and-drop from Finder, by using the "Image Fill" and "Scale to Fill" options. However, in order to see details in the image, I would need to make the cells very large. I'm looking for a way to "zoom in" or make the image "pop out" somehow, either on mouse-over or when I click on the cell.

Best Answer

After a lot of back and forth, trial and error, I have come to the conclusion that this is not yet possible in Numbers, and that Excel is still superior in this regard.

Related Solutions

Copy static cell value in Numbers

You need to use the $ char e.g. like this: =$D$3

Numbers: How to change cell text conditionally

You can do this with the IF function. The syntax is…

┌── IF function returns one of two values when upon an expression's evaluation.
│
│                     ┌── string or calculation for cell to show upon TRUE/FALSE
│                     │   strings should be inside double quotes "like this"
│                ┌────┴─────────┐
IF(if-expression,if-true,if-false)
   └─────┬─────┘
         └── the expression to evaluate
             for example: to test if A1-A2 is negative, you can use (A1-A2)<0
             the result must be a boolean

This results in the following calculation:

IF(Data::A1<0,"Negative","Positive")

Result:

An example for comparing a calculation in the if-expression:

            ┌── from table "Data" do A1-B1
            │
            │          ┌── is the result less than zero (i.e. negative)?
    ┌───────┴───────┐  │
IF((Data::A1−Data::B1)<0,"Negative","Positive")
                         └───┬────┘ └───┬────┘
                             │          └── if false, return "Positive"
                             │          
                             └── if true, return "Negative"

Result:

However, this will return Positive even if the number is 0, so instead…

            ┌── from table "Data" do A1-B1
            │
            │          ┌── is the result less than zero (i.e. negative)?
    ┌───────┴───────┐  │
IF((Data::A1−Data::B1)<0,"Negative",IF((Data::A1−Data::B1)=0,"Zero","Positive"))
                         └───┬────┘                        │ └─┬──┘ └────┬───┘
if true, return "Negative" ──┘           is equal to 0? ───┘   │  return "Positive"
                                                               └── return "Zero"

Best Answer

Related Solutions

Copy static cell value in Numbers

Numbers: How to change cell text conditionally

Related Question