To copy an image in Excel for Microsoft 365 on Windows, click the image’s edge to select it, press Ctrl+C, click the destination sheet or workbook, and press Ctrl+V. Excel inserts a duplicate you can move or resize independently. If you want to copy a group of cells as one picture instead, use the Copy as Picture command.
What You’ll Need
- An Excel workbook with the image you want to copy, or access to the image in another app or website.
- A destination worksheet or workbook where you can paste the copy. If you are copying between workbooks, keep both open while you do it.
- Permission to edit the destination workbook. A protected sheet or restricted workbook may prevent pasting or moving pictures.
These steps are for desktop Excel for Microsoft 365 on Windows. Excel for Mac uses Command+C and Command+V in place of Ctrl+C and Ctrl+V. Excel for the web supports basic picture copying and pasting, although the available commands can depend on your browser and the kind of picture.
Step-by-Step
- Identify what you are copying. Excel can contain a regular picture that floats above the cells, a picture placed inside a cell, or a range of cells that you want to turn into a picture. A floating picture usually has a border and circular or square sizing handles when selected. If clicking the image selects a cell instead, it may be an in-cell picture; if you want a picture of a table or chart area, see step 7.
- Select the image itself. Click once near the middle of the picture. If that selects a worksheet cell or starts editing a cell, click the picture’s outer edge instead. When the picture is selected, sizing handles appear around it and the ribbon may show a Picture Format tab. Avoid clicking a handle, because dragging one resizes the picture rather than selecting it for copying.
- Copy the selected picture. Press Ctrl+C on Windows. You can also right-click the selected image and choose Copy if that command appears. A moving dashed outline may appear around the image; it indicates that Excel has copied the object and is ready to paste it. The original picture remains in place.
- Choose where the duplicate should go. To place it on the same sheet, click an empty area near the intended position. To use another worksheet in the same workbook, click that sheet’s tab. To use another workbook, switch to it and click the destination sheet. If the destination workbook is not open, open it before copying or leave it open while you return to the source.
- Paste the copy. Press Ctrl+V. Excel places a duplicate, often slightly offset from the original, and selects it. If you are copying between workbooks, make sure you have clicked the destination workbook before pasting; otherwise the copy may land back on the source sheet. On a Mac, use Command+C and Command+V.
- Position and size the duplicate. With the new picture selected, drag its body to move it. Drag a corner handle to resize it while keeping its proportions. Dragging a side handle can stretch or squash the image. For finer positioning, use the arrow keys after selecting the image; hold Ctrl while using the arrow keys on Windows to move it in smaller increments. The exact movement increment can vary with Excel’s settings.
- Copy a cell range as a picture when needed. Select the cells you want to reproduce, then choose Home > Copy arrow > Copy as Picture. In the dialog, choose how the picture should look, such as As shown on screen, and select Picture as the format if that option is offered. Click OK, then paste the resulting picture where you need it. This is useful for sharing a formatted table without copying editable cells. The pasted result is a picture, so its text and numbers are not edited cell by cell.
- Copy an image from another app or website. If the source app offers a Copy command for the image, use it, return to Excel, select the destination, and press Ctrl+V. On a webpage, right-click the image and choose Copy image if your browser offers that command; then paste in Excel. If the paste does not work, save or download the image first, then in Excel choose Insert > Pictures and select the saved file. Use only images you have permission to use.
- Check the result before continuing. Click away from the picture to confirm it sits in the right place and is not covering important data. Click it again to confirm it can be selected and moved. Save the workbook, especially if you have copied an image into a different file or made several changes.
In Excel for the web, try selecting the picture and using the browser or Excel copy-and-paste commands. If keyboard paste is blocked or the object behaves differently, use Insert > Pictures to add an image file, or open the workbook in the desktop app for more picture tools. In Excel for Mac, most of the same selection and placement steps apply, but use Command rather than Ctrl for the copy and paste shortcuts.
Common Mistakes
- Copying a cell instead of the picture. If the cell border appears but there are no picture handles, the cell is selected. Click the image’s edge and check for sizing handles before copying.
- Clicking and dragging when you mean to select. Dragging the picture body moves it; dragging a handle changes its size. Select with a click, copy, and then paste before moving the new copy.
- Pasting into the wrong workbook. Excel pastes into the active window. Switch to the destination workbook and select its sheet before pressing Ctrl+V.
- Expecting Copy as Picture to create editable cells. That command makes a visual snapshot. To preserve formulas and editable cell contents, copy the actual cells instead.
- Stretching the picture out of shape. Resizing with a side handle can distort the image. Use a corner handle to keep its original proportions.
- Assuming every picture is a floating object. A picture placed in a cell can behave differently from a picture that floats over the grid. The available options depend on how it was inserted and on your Excel version.
Tips
- Use the selection pane for overlapping images. If you cannot click the image because another object is in front, choose Home > Find & Select > Selection Pane. Select the picture by its listed name, then copy it. The pane is also useful for finding objects hidden behind charts or shapes.
- Keep the picture aligned with the worksheet. If the image should move and resize with particular cells, select it, open the Picture Format tab, choose Align, and check the available alignment options. Excel’s picture positioning settings can vary by build; look for the Size & Properties pane if you need to control how an object behaves when cells move or resize.
- Rename duplicates when the sheet has many objects. Use the Selection Pane to give pictures meaningful names, such as Product front or Logo small. Clear names make it easier to select the intended copy later.
- Use Copy as Picture for a clean handout. A picture of a selected range preserves its displayed appearance more reliably than re-creating a table elsewhere. Review the print layout and zoom level first, since the copied appearance can reflect how the range is displayed.
- Keep the source image available. When a paste between apps fails, inserting the original image file is often more dependable. Common formats such as PNG and JPEG are suitable for many spreadsheet uses. A transparent PNG can be useful for logos placed over colored cells.
- Consider file size. Duplicating a high-resolution picture several times can make a workbook larger. Resize or compress pictures if workbook size becomes a problem, but keep a separate original if you may need the full resolution later.
Troubleshooting
Nothing happens when you press Ctrl+V: First click the destination worksheet, then try again. Check whether the source picture is still selected and copied; if necessary, select it and press Ctrl+C again. If the workbook is protected, ask whether editing or inserting objects is allowed. In a browser, the page or browser permissions may block clipboard access, so try the on-screen paste command or open the file in desktop Excel.
The picture pastes as text, a link, or an unexpected object: This can happen when copying from a website or another program that puts several data formats on the clipboard. Try copying the image itself rather than the surrounding page or text. If the result is still wrong, save the picture as a file and insert it with Insert > Pictures.
The duplicate is hard to find: It may be pasted directly on top of the original or in a nearby position. Select the image and move it slightly to check. If you cannot select it, use Home > Find & Select > Selection Pane to locate the object. Zooming out can also help reveal a picture pasted outside the visible data area.
The image looks blurry or distorted: Avoid enlarging a small source image, which can make it appear pixelated. Use a higher-resolution original when possible. If the shape looks stretched, resize from a corner handle rather than a side handle. Excel’s display can look different at different zoom levels, so check the image at normal zoom and in print preview if it is meant to appear on paper.
Only part of the image appears: The picture may be behind another object, clipped by the visible area, or placed partly beyond the sheet’s current view. Use the Selection Pane to select it, then drag it into view. If you copied a range as a picture, repeat the selection and make sure the entire intended cell range was selected before choosing Copy as Picture.
You cannot copy an image from a protected or shared file: Some workbooks restrict editing or object changes. Check whether the file is read-only, protected, or open with limited permissions. If you have authorization, request an editable copy or ask the workbook owner to enable the changes; do not try to bypass access restrictions.
Frequently Asked Questions
How do I copy an image to another sheet in the same workbook?
Select the picture, press Ctrl+C, click the destination sheet tab, and press Ctrl+V. On a Mac, use Command+C and Command+V. Move the duplicate into position after it appears.
Can I copy an image from Excel into Word or PowerPoint?
Yes. Select the picture in Excel and copy it, then click in the other Office app and paste. If you need a static view of a group of cells, use Copy as Picture first. The pasted appearance and available formats can depend on the destination app.
How do I copy a chart or a group of cells as an image?
For a cell range, select the cells and choose Home > Copy arrow > Copy as Picture, then paste. For a chart, select the chart object and use Ctrl+C and Ctrl+V, or copy it into the destination app. A chart copied as a regular chart may remain editable rather than becoming a flat picture.
Why does Excel select a cell instead of my picture?
The click may have landed outside the image or the image may be placed in a cell. Try clicking the visible image edge. For an object that is difficult to reach, open Home > Find & Select > Selection Pane and select it there.
Will copying a picture also copy its hyperlink?
It depends on how the link was added and how the image is pasted. A hyperlink attached to a picture may carry over in some Excel copy-and-paste operations, but do not assume it has. Test the duplicate by right-clicking it or clicking it in a safe place, and reapply the link if needed.
Can I copy a picture in Excel for the web?
Basic copying and pasting may work, but browser clipboard behavior and picture type can affect the result. If it fails, download or locate the image file and insert it through Excel, or open the workbook in the desktop app for additional picture commands.
Related
- How to Color Cells in Excel Based on Values Automatically
- How to Color Negative Values in Excel Automatically
- How to Color Code Names in Excel with Conditional Formatting
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel File Size Too Large? How to Reduce ItTo reduce a large Excel file, remove unused rows, columns, formatting, images, and duplicate data, then save a…
- How to Change Views in the New Outlook for WindowsIn the new Outlook for Windows, open the View tab to change how your mail or calendar is…
- Scatter Plot Different Colors in Excel: A Clear GuideYes. In Excel, the reliable way to show different colors for different groups in a scatter plot is…
- How to Insert a Check Box in Word and Make It ClickableTo add a clickable check box in Word for Microsoft 365 on Windows, enable the Developer tab, then…
- How to Schedule an Email in Outlook to Send at a Later TimeTo schedule an email in Outlook, write your message, open the menu beside Send, choose Schedule send, and…
- Schedule an Email in Outlook: Step-by-StepTo schedule an email in Outlook, write your message, open the menu beside Send, choose Schedule send (or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.