To put a picture in an Excel cell comment, create a legacy note, right-click its border, open its formatting options, and set the note’s fill to a picture. In current Microsoft 365 for Windows, the feature is called a Note; it is different from a threaded Comment. The picture appears in the note pop-up when someone selects or hovers over the cell, depending on Excel’s display settings, rather than sitting directly inside the worksheet cell.
This is useful for showing a product photo, map, signature, or other visual reference without taking up space in the grid. You will need a desktop version of Excel that exposes the legacy note-formatting controls and an image file saved somewhere you can access. The steps below are for Microsoft 365 on Windows. Excel for the web does not provide the complete picture-fill workflow, and the equivalent controls may differ or be unavailable in Excel for Mac.
What You’ll Need
- A workbook open in the desktop version of Microsoft Excel for Microsoft 365 on Windows.
- A cell where you want the image note to appear. You can add a note to a blank cell or one that already contains data.
- An image file saved on your computer or in a location you can browse to, such as a JPG or PNG. A small, clearly cropped image is usually easier to view than a very large original.
- Permission to edit the workbook. If it is read-only, protected, or shared with restrictions, you may need to save an editable copy or ask the workbook owner for access.
Step-by-Step
- Choose the target cell. Click the cell that should carry the image. The picture will belong to that cell’s note; it will not become a separate worksheet object anchored independently on the grid. If the cell already has a note, you can edit that note instead of creating another one.
- Insert a legacy note, not a threaded comment. Right-click the cell and choose New Note. Alternatively, use Review > Notes > New Note on the ribbon. Excel creates a note box, often with your account name already shown. In older releases, this feature may be labeled New Comment, because older Excel used the word comment for what current Microsoft 365 calls a note.
- Close or leave the note text area as needed. The note may contain text as well as a picture. You can keep a short caption, remove placeholder text, or leave the note blank if you want only the image. To remove text, click in the note and edit it as you would a text box. Do not delete the note itself; you need it to hold the picture fill.
- Select the note’s border. Move the pointer to the outside edge of the note until the pointer indicates that the note object, rather than its text, is selected. Click the border. This distinction matters: formatting the text changes font and paragraph settings, while formatting the border opens the object’s fill and line controls.
- Open the note-formatting dialog. With the border selected, right-click the border and choose Format Comment or Format Note, depending on the wording in your Excel build. You can also try selecting the border and pressing Ctrl+1 on Windows. If the dialog does not appear, click the border again and confirm that the note object, not the insertion point in its text, is selected.
- Open the fill controls. In the formatting dialog, select the Colors and Lines tab. In the Fill section, open the Color menu and choose Fill Effects. In the Fill Effects window, select the Picture tab. These are legacy formatting controls, so they may not appear when you are formatting a modern threaded comment.
- Choose the image file. Select Select Picture, browse to the image, select it, and confirm the selection. Depending on the dialog, Excel may show a preview or a file-selection window before returning to Fill Effects. Check that the preview is the intended image, then confirm to close the Fill Effects window.
- Apply the fill and close the dialog. Select OK in the remaining formatting dialog to apply the picture to the note. The note should now show the image as its background. If you kept text in the note, check that the words remain readable against the picture; a busy or high-contrast image can make them difficult to see.
- Resize and check the note. Click away from the note, then select or hover over its cell to display it. Drag a sizing handle on the note border to make the display area larger or smaller. The picture fills the note area, so resizing the note changes how the image is shown and may affect its apparent proportions. Adjust the box until the important parts are visible, then click another cell to dismiss it.
- Save and verify the workbook. Save the file, close it, and reopen it if the workbook will be used by other people. Confirm that the note and image still appear. If you share the workbook, tell recipients that the picture is inside a legacy note; the experience and editing controls can differ in Excel for the web, Mac, or other spreadsheet applications.
The picture is a fill for the note’s rectangular area, not an image that Excel places into the cell’s value. You can still sort and filter the worksheet based on cell contents, but the note’s image is supplementary information. If a reader needs to print or export the image as part of the worksheet itself, insert a regular picture from Insert > Pictures instead and position it over the relevant cells.
Common Mistakes
- Choosing New Comment instead of New Note. In current Microsoft 365, a threaded comment is designed for conversation and replies. It does not offer the same picture-fill setting. Use New Note for the legacy pop-up that can have a picture background.
- Right-clicking inside the note text. That opens text-editing options, not the note’s fill settings. Select the outer border first, then open the formatting dialog from the border’s context menu.
- Expecting the picture to appear in the cell all the time. A note is normally hidden until its cell is selected or hovered over. If the image must remain visible on the sheet, use an inserted picture object rather than a note fill.
- Using an image that is too detailed or oversized. Tiny labels, panoramic pictures, and high-resolution photographs can be hard to read in a small note. Crop the image or make the note bigger before deciding that the fill failed.
- Assuming the picture will preserve its original proportions. The note is a rectangular display area. Changing its height or width can make the picture look stretched or cropped, depending on how the fill is rendered. Inspect the finished note at its actual size.
- Formatting a protected or read-only workbook. A locked worksheet or a file opened without editing permission can prevent note changes. Check the workbook’s editing status and, if appropriate, ask the owner to unlock the sheet or provide an editable copy.
Tips
- Keep the image focused. Crop away empty margins and unrelated details before inserting it. This makes a label, product, or diagram easier to recognize in the limited space of a note.
- Set a useful note size before sharing. Select the cell and display the note, then drag its border handles. Leave enough room for the important visual details without covering a large part of the worksheet.
- Use text as a fallback description. Add a short caption or explanation in the note when it helps identify the image. For example, a note on a part-number cell could say that the picture shows the front view of the part. That description is also useful if someone opens the workbook in software that does not display the picture fill properly.
- Use a consistent approach in a catalog. If many cells need images, use similar image dimensions and note sizes so the pop-ups feel predictable. Keep a separate copy of each source image in a clearly named folder in case you need to update or replace one later.
- Consider whether a note is the right format. Notes are convenient for supplementary visuals, but they are not ideal for a photo gallery or a worksheet that must show every image at once. Insert pictures directly on the sheet for visible illustrations, or use links to a managed image folder when many large files would make the workbook unwieldy.
- Test the file with its intended audience in mind. A picture fill that works in Excel for Windows may not have the same editing experience in a browser, on a Mac, or in another spreadsheet program. If recipients use different software, share a PDF or separate image files as a dependable visual reference.
Troubleshooting
The Format Comment or Format Note option is missing: First make sure you created a note. Right-click the cell and look for Edit Note or Show/Hide Note. If the cell instead has a threaded conversation, create a separate note through Review > Notes > New Note. Then select the note’s outer edge before opening its context menu. Also check whether the worksheet is protected or the workbook is read-only.
There is no Fill Effects option: Confirm that you are in the legacy note-formatting dialog, under Colors and Lines, and that the note border is selected. If you are working in Excel for the web or cannot find the legacy controls in your Mac version, open the workbook in desktop Excel for Windows and try the steps there. The modern threaded-comment panel is not the right place to look for picture fill.
The image does not show after selecting it: Return to the note’s fill settings and check that you confirmed both the Fill Effects window and the note-formatting dialog. Reopen the note to refresh its display. If needed, remove the fill and select the image again from a local file with a common format such as JPG or PNG.
The image looks distorted, cropped, or hard to read: Resize the note and inspect it again. Try a better-cropped image with a more suitable aspect ratio, and remove text that overlaps the important part of the picture. If you cannot make it clear in a note-sized box, place the picture on the worksheet instead.
The image disappears for another person: Ask the recipient to open the workbook in desktop Excel and check the cell’s note. Some viewers do not support the same legacy note formatting. Save the workbook after applying the fill, and consider including the image as a separate file or exporting a reference copy to PDF if it is essential.
Frequently Asked Questions
Can I put an image inside a modern Excel comment?
Not as a picture background using the legacy note-fill method. Current Microsoft 365 threaded comments are for discussions. Create a Note instead, then use its fill settings.
Is a Note the same as a Comment in Excel?
No. In current Microsoft 365, a Comment is a threaded conversation with replies, while a Note is the older cell pop-up. Older Excel versions used the word comment for the older feature, which is why instructions and menus can be confusing.
Will the image show inside the cell without clicking it?
No. The image is part of a note that is usually hidden until the note is displayed. To keep an image visible in the worksheet grid, use Insert > Pictures and position the picture over the cells.
Can I add text as well as an image?
Yes. A note can contain text while using a picture fill. Keep the caption brief and check contrast and legibility after applying the image, since text placed over a busy picture can be difficult to read.
Can I do this in Excel for the web or on a Mac?
Excel for the web does not expose the full Windows legacy picture-fill workflow. Excel for Mac has different menus and may not show the same controls in every build. For the steps on this page, use desktop Excel for Microsoft 365 on Windows.
Can I use a picture in several cells at once?
The note belongs to an individual cell, so add and format a note for each cell that needs its own image. For a large number of images, inserting pictures on the sheet or linking to image files may be easier to maintain.
Related
- Insert 0 in Excel Before a Number: Text or Formatting
- How to Indent a New Line in an Excel Cell: Easy Steps
- How to Indent in Excel Without Changing Cell Contents
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Find a Table in Excel: Search and NavigationTo find a table in Excel, search for a word or value you expect it to contain, then…
- Excel Dynamic Title on Box Plot: Link It to a CellTo make an Excel box plot title dynamic, put the title text or a formula in a worksheet…
- Google Sheets Checkbox Column: Add and Use CheckboxesTo add a checkbox column in Google Sheets, select the cells where the checkboxes should go, then choose…
- Hide and Unhide Columns in Excel: ShortcutsIn Excel for Microsoft 365 on Windows, select a column or any cell in it and press Ctrl+0…
- Excel Remove Duplicates: Keep One Copy of Each RowYes. In Excel for Microsoft 365 on Windows, select your data and choose Data > Remove Duplicates; Excel…
- Share an Outlook Calendar With a QR Code: How It WorksYes—but Outlook does not generally create a QR code for sharing a calendar. You can publish a calendar…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.