Share via

MacOS Excel - How can I insert an image into a cell

Anonymous
2022-08-10T01:46:25+00:00

Hi,

how can I insert a jpeg into a cell?

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2022-08-12T18:50:42+00:00

    Hi again,

    Apple Numbers treats the cell as a shape and allows you to format the shape fill property with a picture. That's one way pictures in cells can be handled. You can't use the picture in a cell in a cell formula.

    Google Sheets treats a picture in a cell as an object in the cell. That's another way to treat pictures in cells.

    Microsoft Excel treats pictures in cells as data objects. You can use cell formulas and arrays with pictures the way Microsoft is doing it.

    Given that spreadsheets are primarily used for analyzing data, I think Microsoft's approach is ultimately going to prove to be the most useful.

    1 person found this answer helpful.
    0 comments No comments

11 additional answers

Sort by: Most helpful
  1. Anonymous
    2022-08-11T19:18:12+00:00

    Thanks. What is the ALT key on a mac?

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2022-08-11T19:12:13+00:00

    Hi

    Thank you for posting your query. My name is Clarence, I'll be more than happy to assist you with your concern.

    Here are the steps to insert a picture into a cell in Excel:

    Go to the Insert tab. Click on the Pictures option In the ‘Insert Picture’ dialog box, locate the pictures that you want to insert into a cell in Excel. Click on the Insert button. Re-size the picture/image so that it can fit perfectly within the cell. Place the picture in the cell.

    Note: A cool way to do this is to first press the ALT key and then move the picture with the mouse. It will snap and arrange itself with the border of the cell as soon it comes close to it.

    Go to this link for your reference and other troubleshooting procedures https://trumpexcel.com/insert-picture-into-excel-cell/

    https://www.exceldemy.com/insert-picture-into-excel-cell/

    Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.'

    Do not hesitate to message us if you need further assistance.

    Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

    Best Regards, Clarence

    1 person found this answer helpful.
    0 comments No comments
  3. Jim G 134K Reputation points MVP Volunteer Moderator
    2022-08-10T16:26:52+00:00

    Hi Steven,

    Currently, only images from data types can exist within the grid. All other images float on top of the grid, and you can "fake it" by following the steps provided by Mukesh.

    Here's an example on how to insert a country flag into the grid using the Geography data type. After applying the Geography data type, click the in-cell button that looks like a modesty screen to display the data pop-up. Mouse over the image content and click the Extract image to grid button.

    Image

    You will then see the image and it is actually within the cell. Select a cell having an image and you can see in the formula bar that it is a cell formula.

    Image

    As this is relatively new functionality, you can see where Microsoft is going with this. My hunch is that at some point relatively soon we will be able to use cell formulas to directly insert pictures, perhaps from web pages or local files and have the pictures live inside a cell.

    Because this functionality is new, right now would be a good time for you to think about pictures within cells in the grid. What kind of pictures (.jpg .png etc) would you want in the grid? How would you get them into the grid (cell formula? Paste?) What options would you want to have for pictures in the grid (use in cell formulas? treat as picture objects?). You can share you thoughts in replies, and when you feel ready, you can share your thoughts directly with Microsoft using the Excel Menu Bar and choosing Help > I Have a Suggestion.

    Here's a video that shows how to use a cell formula to display pictures that float above the grid:

    https://youtu.be/S36EITzqSU0

    Here's another similar video, but with a twist

    https://www.extendoffice.com/documents/excel/4025-excel-dynamic-image-in-cell.html

    1 person found this answer helpful.
    0 comments No comments
  4. Anonymous
    2022-08-10T02:24:28+00:00

    Hi ,

    I'm Mukesh and I will be happy to help you out with your question.

    Here are the steps to insert a picture into a cell in Excel:

    -Go to the Insert tab.
    -Click on the picture option.
    -In the ‘Insert Picture’ dialog box, locate the pictures that you want to insert into a cell in Excel.
    -Click on the Insert button.
    -Re-size the picture/image so that it can fit perfectly within the cell.

    How to Insert Picture Into a Cell in Excel https://trumpexcel.com/insert-picture-into-excel-cell/

    note: this is a non-microsoft website. the page appears to be providing accurate, safe information.watch out for ads on the site that may advertise products frequently classified as a pup (potentially unwanted products). thoroughly research any product advertised on the site before you decide to download and install it.'

    I hope this information helps. If you have any questions please let me know and I will be glad to help you out.

    Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

    Regards
    Mukesh

    1 person found this answer helpful.
    0 comments No comments