In Excel for Microsoft 365 on Windows, select a cell and choose Insert > Pictures > Place in Cell > This Device, then choose your image. Excel puts the picture in the cell, but a cell cannot also hold ordinary text at the same time. For a picture with a readable label, put the image and text in neighboring cells; if you need text visually on top of the picture, use a floating picture and a text box. The steps below explain both approaches and how to keep the layout stable.
What You’ll Need
- A workbook in Excel for Microsoft 365 and an image file you can access, such as a PNG or JPEG.
- A plan for where the label should appear: beside the image, below it, or over it.
- Enough row height and column width to show the picture and its text clearly.
The Place in Cell command may not appear in every Excel build, because Microsoft rolls out features over time. If it is missing, update Excel or use the floating-picture method in Step 7. On Mac and Excel for the web, the command names and availability can vary by version; use the equivalent picture insertion option if available, or use a floating picture and arrange the text in a neighboring cell.
Step-by-Step
- Choose how the text should relate to the image. For a product list, staff directory, or inventory sheet, the most reliable setup is one image cell and one text cell on the same row. For example, put a product photo in A2 and its name and details in B2. This keeps the text editable, searchable, and sortable as normal cell content. If the text must appear over the picture, use a floating picture with a text box; that creates a visual grouping, not a single cell containing both items.
- Prepare the cells and worksheet. Select the column where the image will go and make it wide enough for a useful thumbnail. Select the row and set a suitable height using Home > Format > Row Height. If the label will sit beside the image, make the text column wider too. You can also type the label into its cell now, which makes it easier to judge the required space. Keep the image and label columns adjacent so each row reads as one record.
- Insert the picture into its cell. Select the destination cell, then choose Insert > Pictures > Place in Cell > This Device. Browse to the image, select it, and choose Insert. If you are choosing an image from another source, such as Stock Images, open that source from the Pictures menu and follow its prompts. Check the result before adding more pictures. A picture placed in a cell is treated as cell content, so it moves and resizes with that cell when you change the grid.
- Add the text in a neighboring cell. Select the cell beside the picture and type the label, such as a name, item number, or short description. Press Alt+Enter in a cell on Windows to start a new line within that cell, or turn on Home > Wrap Text so longer text displays on multiple lines. On Mac, the in-cell line-break shortcut differs by keyboard and Excel build; use the Mac shortcut shown in Excel Help for your version, or rely on Wrap Text. Keep essential text in a normal cell rather than embedding it in a graphic.
- Make the picture and label fit together. Adjust the image column width and row height until the picture is legible without making the row unnecessarily large. Then adjust the text column width and turn on Wrap Text if needed. Use the alignment buttons on the Home tab to position the label, for example, top-aligning a longer description with the top of its image. Excel changes the in-cell picture with the cell dimensions, so inspect the image after resizing. If the visible framing is not right, adjust the row or column dimensions and use the available picture crop controls for that image, if offered.
- Repeat the layout consistently. Use the same image-column width and row height for each record. Add the next picture to the corresponding cell in the image column and its text to the neighboring cell on the same row. Consistent dimensions make the list easier to scan and reduce the chance that a label appears to belong to the wrong picture. If you sort or filter the records, include both the image and text columns in the same table range so the paired information stays together.
- Use a floating picture if Place in Cell is unavailable or you need an overlay. Choose Insert > Pictures and insert the image normally, without Place in Cell. Resize and position the picture over the worksheet cells. To make it move and resize with the grid, select it, open Picture Format > Size or the picture formatting pane, and look under Size & Properties > Properties for Move and size with cells. The exact pane labels can differ across builds. To put text visibly on the image, insert a text box from Insert > Text Box, type the text, and position the box over the picture. Set the text box fill and outline to suit the design. Treat the picture and text box as separate objects; they can shift independently when rows or columns change, so check their alignment after editing. On Mac, picture and shape formatting controls may appear in a different pane, but the same principle applies.
Common Mistakes
Expecting one cell to hold both a picture and normal text is the most common misunderstanding. Place in Cell makes the picture the cell’s content; it does not add a picture alongside a typed value in that same cell. Keep the label in the next cell, or use a separate text box when an overlay is essential.
Inserting a picture normally and assuming it is attached to a cell can also cause trouble. A floating picture sits above the worksheet grid and can cover cells. Set its object property to move and size with cells when appropriate, or use Place in Cell for a cell-based image. Also avoid resizing only one row in a list: uneven heights can make thumbnails and labels look inconsistent.
Putting the label in the wrong row or sorting only one column can separate an image from its description. Keep each record on one row and sort the complete table range, not just the image or label column. Finally, do not use a picture of words when the words need to be searched, copied, or read by assistive technology; enter them as text in a worksheet cell.
Tips
- Use a simple two-column pattern. Put thumbnails in one column and names or descriptions in the next. This is easier to maintain than placing text boxes over many pictures.
- Use short, specific labels. A concise name in the main text cell and extra details in another column can prevent rows from becoming excessively tall. Keep identifiers as text when leading zeroes matter.
- Use a table for a growing list. Select the complete range, including image and label columns, and choose Insert > Table. Tables make it clearer which fields belong together and provide filtering controls. Verify that your Excel build handles your in-cell pictures as expected when sorting or filtering.
- Keep image files organized. Use descriptive filenames and a consistent source folder before inserting pictures. If you later replace a picture, a clear filename makes it easier to select the intended file.
- Check accessibility and legibility. Keep important information in worksheet text, use adequate contrast for any text box over a picture, and avoid tiny thumbnails. If the picture formatting pane offers alt-text controls for the image type you inserted, add a concise description for readers who use assistive technology.
- Save and review the workbook. After arranging images, save the file and reopen it or check it on the device where it will be used. Differences in window size, Excel version, and zoom can change what is visible on screen, even when the underlying row and column dimensions are unchanged.
Troubleshooting
Place in Cell is missing: Confirm you are using a current Microsoft 365 build and that you opened the Pictures menu on the Insert tab. Some features arrive gradually or differ by platform. Check for Office updates, then restart Excel. If the command still is not available, insert the image as a floating picture and set its cell-positioning property, or keep it beside the text as a normal object.
The picture looks too small, too large, or oddly framed: In-cell pictures follow the dimensions of their cells. Increase the column width or row height and inspect the result. If the picture is still framed poorly, look for picture crop or fit controls available for that image. Do not stretch a floating image by dragging only a side handle if preserving its proportions matters; use a corner handle or the size controls instead.
The label is hidden or cut off: Widen the text column, increase row height, or select the label cells and choose Home > Wrap Text. Check that the neighboring cell is not obscured by a floating picture and that the font color contrasts with the cell background. If the text is an overlay, select the text box itself and bring it in front of the image using the available arrange controls.
The image shifts when you edit the sheet: If it is a floating picture, open its formatting properties and choose the appropriate cell behavior, such as Move and size with cells. If it is an in-cell picture, check that you resized the intended row or column. After sorting, confirm that the entire table range was selected so pictures and labels remain paired.
The workbook looks different on another computer: Confirm that the recipient is using an Excel version that supports the image feature and that the file has finished syncing if it is stored online. Ask them to open the workbook in Excel rather than a viewer that may not support in-cell images or floating objects fully. For important shared sheets, test a copy in the recipient’s environment before relying on a particular layout.
Frequently Asked Questions
Can I put a picture and typed text in the exact same Excel cell?
No. An Excel cell holds one cell value or an in-cell picture, not both as independent contents. Put the text in a neighboring cell, or use a floating image with a text box if you need a visual overlay.
What is the difference between Place in Cell and a regular picture?
Place in Cell makes the image part of the cell’s content and ties it to the cell’s grid position and dimensions. A regular inserted picture is a floating object above the grid. It can cover cells and needs its positioning behavior set separately.
Will the picture stay with its label when I sort?
It should stay with the label when both are in the same row and you sort the full range containing both columns. Sorting just one column can break the pairing. Check the result after sorting, especially if the workbook mixes in-cell images and floating pictures.
Can I add a caption over the picture?
Yes, as a visual arrangement: insert a regular floating picture, then add a text box on top of it. The caption is not stored in the picture’s cell, and the two objects may need repositioning if the sheet layout changes. For data that must be searched or sorted, keep a copy of the caption in a worksheet cell.
Can I do this in Excel for Mac or Excel for the web?
Availability and menu labels for Place in Cell depend on the Excel version and update. Look for a Place in Cell option in the Insert tab’s Pictures menu. If it is absent, insert a floating picture and keep the text in a neighboring cell; formatting panes and shortcuts may differ from Windows.
Related
- How to Group in Microsoft Excel: Rows, Columns, and Sheets
- Hide Cells in Excel: Shortcut Keys for Rows and Columns
- How to Group Rows in Excel With Plus Signs at the Top
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Copy Excel Sheet to Word: Methods and FormattingTo copy Excel data into Word, select the cells in Excel, press Ctrl+C, click where the content should…
- Excel Time Difference in Seconds: How to CalculateWith a start time in A2 and an end time in B2, enter =(B2-A2)*86400 to calculate the difference…
- How to Turn On Track Changes in Microsoft Word DocumentsTo turn on Track Changes in Word for Microsoft 365 on Windows, open the document and select Review…
- Google Sheets IF Blank: Formulas, Examples, and FixesIn Google Sheets, use =IF(A2="","Blank","Not blank") to test whether A2 is empty or returns an empty string; replace…
- How to Delete an Extra Page in WordTo delete an extra page in Word, first show formatting marks with Ctrl+Shift+8 on Windows or Command+8 on…
- Excel Always Not Responding? Causes and FixesNo—Excel does not always freeze because the program is broken. A Not Responding message usually means Windows is…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.