To put a picture inside an Excel comment box, create a legacy note, then set its fill to the picture: right-click the cell, choose New Note, right-click the note’s border, select Format Comment, and use Fill Effects on the Colors and Lines tab. In current Excel, the picture-fill option applies to notes (the old-style comments), not threaded comments.
What You’ll Need
- Excel for Microsoft 365 desktop on Windows. The steps below use its ribbon and dialog names.
- A picture file saved somewhere you can browse to, such as a PNG or JPG. Keep a copy of the original image; changing the note’s fill does not edit that file.
- A workbook saved in a modern Excel format, such as .xlsx. If you are using a shared or protected workbook, you may need permission to add or format notes.
Excel uses the words Comments and Notes for different features. Threaded comments support conversations and replies. Notes are the old-style, single-box annotations that can have a formatted background. People may still call a note a comment box, which is why it is important to choose New Note rather than New Comment.
Step-by-Step
- Open the workbook in desktop Excel. If the file is open in a browser, choose the option to open it in the desktop app. Excel for the web does not provide the full Windows Format Comment and Fill Effects workflow described here. Save the workbook before you begin, especially if you are working on an important file.
- Choose the cell that should contain the note. Click the cell once to select it. The note is attached to that cell, so choose a cell whose meaning will still be clear to someone reading the worksheet later. You do not need to select the cell’s text or enter edit mode.
- Create a note, not a threaded comment. Right-click the selected cell and choose New Note. In some ribbon layouts, you can also use Review > Notes > New Note. A note box appears, usually with your name and a text cursor. If the context menu says New Comment, look for New Note instead; a threaded comment does not offer the picture-fill setting.
- Add any text the reader needs. Type a short description or instruction in the note. For example, a picture next to a product code could show the product, while the note text identifies the model or explains what to inspect. Keep the text brief because it will sit on top of, or in front of, the note’s background image.
- Select the note’s border. Click outside the text area if necessary, then click the outline of the note box so the whole note is selected. This is important: if you right-click while the insertion cursor is active inside the text, you may see text-editing options instead of formatting options. A selected note typically shows handles around its edge.
- Open the note formatting dialog. Right-click the selected border and choose Format Comment. The label may still say Comment even though the object you created is a Note. In the dialog, open the Colors and Lines tab. If you do not see Format Comment, close the menu, select the border more carefully, and try again.
- Open the picture fill controls. In the Fill area, open the Color drop-down and choose Fill Effects. In the Fill Effects window, select the Picture tab, then click Select Picture. Browse to the image file, select it, and confirm the file selection. The picture should appear as the note’s fill preview.
- Apply the fill. Confirm the Fill Effects window, then click OK in Format Comment. If the dialog offers a picture aspect-ratio option, use it when keeping the image’s original proportions matters. Depending on the image and note dimensions, Excel may still crop or stretch the picture to fill the available area.
- Adjust the note and check how it looks. Drag the note’s edge or corner handles to change its size. Click elsewhere to close it, then hover over the cell to display it again. If you want it to stay visible, right-click the cell and choose Show/Hide Note (or use the corresponding command under Review > Notes). Check that the image and any text are legible at the size readers will see.
- Save and verify the workbook. Save the file, close it, and reopen it if the picture is important to the worksheet. Confirm that the note still appears and that the fill is present. If you plan to send the workbook to another person, ask them to open it in desktop Excel; another spreadsheet app may display Excel note formatting differently.
Common Mistakes
- Choosing New Comment instead of New Note. Threaded comments are designed for discussion and replies; they do not use the legacy note’s fill-formatting dialog. Start with New Note when the picture needs to be inside the box.
- Formatting the text instead of the note shape. The note border must be selected before you open Format Comment. If the cursor is blinking in the text, right-clicking usually opens text options. Click the outline and look for selection handles.
- Using Insert Picture and expecting it to become the fill. Inserting a picture on the worksheet creates a separate picture object. It may sit over cells, but it is not the note’s background and may move independently. Use Fill Effects > Picture for the note fill.
- Making the note too small. A wide picture placed in a narrow note may be cropped or compressed, and text can become difficult to read. Resize the box after applying the fill and inspect the result at normal worksheet zoom.
- Expecting the image to show all the time. Notes commonly appear when a reader points to the cell, unless the note is set to remain visible. A picture fill does not turn the note into a permanent worksheet image.
Tips
- Use a simple picture. A close-up, icon, or product image with a clear subject works better than a busy photo. Small note boxes cannot show fine detail, and a high-contrast image can make note text hard to read.
- Resize before judging the crop. The note’s proportions affect how its fill appears. Try a wider or taller note shape before replacing the picture; a different box shape may show more of the image.
- Keep important information in the worksheet too. A note can be overlooked, hidden, or displayed differently in another program. Put essential values or instructions in cells, and use the picture as supporting context rather than the only source of information.
- Use concise text and useful alternative context. Add a short description of what the image depicts or why it matters. If the image itself carries essential information, also state that information in ordinary cell text so it remains available when the note is not open.
- Check the workbook’s sharing and display needs. If recipients use Excel for the web, a phone, or another spreadsheet program, test the file in the version they will use. For a picture that must be visible without hovering, insert a normal worksheet picture instead and position it beside the relevant cell.
Troubleshooting
There is no New Note option. Make sure you are using Excel desktop rather than the browser version, and check the selected cell’s right-click menu or Review > Notes. If you only see New Comment, your app or menu layout may not expose legacy notes in the same place. Update or open the file in desktop Excel for Windows and look under Review for Notes commands.
Format Comment is missing. You may have selected the cell, the note text, or a threaded comment instead of the note border. Click the cell to show the note, click its outer edge until the box handles appear, and right-click the edge. For a threaded comment, create a separate note; the threaded comment itself cannot be given this picture fill.
The image does not appear after selecting it. Reopen the note’s Format Comment dialog and confirm that the picture was selected under Colors and Lines > Fill > Color > Fill Effects > Picture. Use a common image format such as PNG or JPG, confirm the file opens outside Excel, then select it again. Apply both dialog boxes with OK; closing the file picker alone does not apply the fill.
The image is cropped, stretched, or covered by text. Resize the note and check the picture aspect-ratio setting in Fill Effects, if available. A fill is constrained by the note shape, so the entire image may not fit without empty space or cropping. Shorten the note text, enlarge the box, or prepare a crop with the proportions you want before selecting the file.
The note looks different for someone else. Confirm that the workbook was saved after formatting and that the recipient is opening the current copy in desktop Excel. Excel for the web and other spreadsheet programs may not reproduce legacy note formatting exactly. If consistent display is essential, use a worksheet picture for the visual and keep the note text separate.
Frequently Asked Questions
Can I put an image in a threaded Excel comment?
No. The picture-fill method is for legacy notes. If you need the image inside a box, create a Note and apply the picture through Format Comment. A threaded comment can still be used for replies, but its appearance is different.
Is an Excel note the same thing as a comment?
Not in current Excel. A Note is the older, single-box annotation. A Comment is a threaded conversation with replies. The formatting dialog may still use the older label Format Comment for a note, which can be confusing.
Can I do this in Excel for the web?
The web app does not provide the same full Fill Effects picture workflow as Excel for Microsoft 365 on Windows. Open the workbook in the desktop app to apply the image fill, then save it. Check the display in the browser if your recipients will use the web version.
Can I show the picture without hovering over the cell?
Yes, you can set the note to remain visible using the cell’s Show/Hide Note command. Otherwise, the note usually appears when the pointer is over its cell. For a picture that should always be visible as part of the worksheet, insert it as a regular picture object instead.
Will the image move if I sort or filter the worksheet?
The fill belongs to the note, and the note is attached to its cell, but object behavior can depend on worksheet settings and how rows are changed. Test sorting or filtering on a saved copy when positioning matters, and verify the note afterward.
What is different on a Mac?
Menu names and dialog layouts can differ in Excel for Mac, and the Windows steps above may not match exactly. If your Mac version offers Format Note or Format Comment for a selected note, look for a picture option in its fill controls. If that option is unavailable, use desktop Excel for Windows to apply the fill.
Related
- How to Import an Excel Sheet Into Word: 3 Simple Methods
- How to Import an Excel Spreadsheet Into a Word Document
- Import Excel into a SharePoint List: Step-by-Step
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Bar Plot: How to Create and Format OneIn Excel for Microsoft 365 on Windows, select your category and value columns, then choose Insert > Insert…
- COUNTIF Blank in Google Sheets: Count Empty CellsTo count blank cells in Google Sheets, use =COUNTIF(A2:A100,""); this counts empty cells in the specified range, including…
- How to Delete a Middle Page in Word Without Shifting TextTo delete a middle page in Word, go to that page, select its contents, and press Delete. In…
- Excel New Paragraph in Cell: Line Breaks ExplainedTo start a new paragraph inside an Excel cell in Microsoft 365 for Windows, edit the cell, place…
- Unmerge Cells in Excel: Keyboard Shortcuts and StepsTo unmerge cells in Excel for Microsoft 365 on Windows, select a merged cell or merged range, then…
- Excel Find and Replace Shortcut: Keys, Options, and TipsIn Excel for Microsoft 365 on Windows, press Ctrl+H to open Find and Replace, then enter the text…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.