To copy cells in Excel as an image, select the range, choose Home > Copy ▼ > Copy as Picture, pick how it should look, and click OK. Then go to the destination and press Ctrl+V on Windows. This creates a picture of the selected cells rather than another editable copy of their values.
What You’ll Need
- Excel for Microsoft 365 on Windows, with the worksheet and range you want to copy.
- A destination, such as another worksheet, a Word document, PowerPoint slide, email, or chat window. The destination must accept pasted images.
- If you are using Excel for the web, open the workbook in the desktop app if you need the built-in Copy as Picture command; availability can differ in the browser.
Decide whether the image is for on-screen use or printing before you copy. This helps Excel capture the range in the appropriate appearance.
Step-by-Step
- Prepare the cells you want to show. In the worksheet, select the rectangular cell range to include. For example, to show a small sales summary, select its title, column headings, and data cells together. Apply the number formats, borders, fills, font sizes, and alignment you want first. The picture reflects the range’s appearance when it is copied, so make corrections now rather than expecting the pasted image to update later. If you only want part of a table, select just those cells. Avoid including blank rows or columns unless you want them in the image.
- Open Copy as Picture. Go to Home, find the Clipboard group, click the arrow beside Copy, and choose Copy as Picture. In some ribbon layouts the command is shown in the Copy menu without the full group label. Make sure you choose Copy as Picture, not the regular Copy button, when your aim is a picture rather than cells. If the command is hard to find, widen the Excel window or expand the ribbon; a narrow window can collapse ribbon controls.
- Choose the appearance and format. In the dialog, select As shown on screen when the image is for a document or presentation and should match the worksheet view. Choose As shown when printed when you want the print-oriented appearance, including relevant page layout and print formatting. Under the format choices, select Picture for a typical Office image. Bitmap is another option, but it can look less sharp if enlarged. Click OK to put the captured range on the clipboard. If the dialog does not appear, check that a cell range is selected and try opening the Copy dropdown again.
- Go to the destination. Click the worksheet, document, slide, message, or other app where you want the image. In Excel, click an open area of the destination sheet; the pasted picture is a floating object over the grid, not cell content stored inside a single cell. In another app, place the insertion point or click the location where pictures can be inserted. If you need the picture in a separate file, paste it into an image-capable app first and save from there.
- Paste the image. Press Ctrl+V on Windows. In Excel, the picture should appear with selection handles around its edges. In Word or PowerPoint, it should appear as a picture object in the document or slide. You can drag a corner handle to resize it while keeping its proportions. If you need it in another worksheet, paste it there just as you would in a document. Don’t press Ctrl+C again before pasting: that replaces the copied picture on the clipboard.
- Check the result and save. Zoom in enough to inspect small text, cell borders, and any symbols. If the image is too large or small, resize it using a corner handle rather than a side handle, which can stretch it. For a new capture, return to the source sheet, adjust the range or formatting, and repeat Copy as Picture. A pasted picture is a snapshot: changing the source cells afterward does not change the image. Save the destination file after you are satisfied.
On Mac, the same feature is generally available from the Home tab’s Copy dropdown as Copy as Picture, although ribbon placement can vary by Excel build. Use Command+C and Command+V for the standard copy and paste shortcuts on Mac. If you do not see the picture command in Excel for the web, use the desktop app rather than assuming a normal copy will create an image.
Common Mistakes
- Using ordinary Copy and expecting a picture. Normal copying usually pastes cells, formulas, or formatting into Excel. Start with Copy as Picture when the result must be a static image.
- Selecting too much or too little. A missed heading or total will not magically appear in the image, and an accidental blank column can make the result look oddly wide. Review the selection outline before opening the command.
- Expecting the image to stay connected to the source. Copy as Picture captures the current appearance. It is not a live link to the cells, so later edits to the table do not refresh the image.
- Resizing from a side handle. This can make text or cell proportions look distorted. Drag a corner handle to resize evenly, and avoid enlarging a small capture far beyond its original size.
- Assuming the picture is inside a cell. In Excel, pasted images are objects positioned over the worksheet grid. They can cover cells and may move or resize independently of the data underneath.
Tips
For a clean image, hide distracting worksheet elements before capturing if they are not part of the intended view. Use a sensible zoom level, but remember that zoom changes how the sheet appears on screen; select the print-oriented option when the printed layout matters more than the current view. If readability is important, increase the source font size or use a smaller range instead of relying on a large enlargement after pasting.
Consider the destination before choosing a format. Picture is usually a good default for Office documents and slides. If the destination displays a bitmap more reliably, try the Bitmap choice and compare the result. Different apps can interpret clipboard image formats differently, so check the pasted image in the actual place it will be used. For an email, paste into the message body and verify the image is visible before sending; some email systems may handle pasted images differently.
Keep an editable version of the source table in the workbook, even if you share the picture. That way you can correct figures and make a fresh image later. If the destination is another Excel sheet, position the picture away from important cells and use the picture’s size and placement controls as needed. If you need it to align precisely, adjust the worksheet zoom and use the grid as a visual guide, then inspect the image at normal viewing size.
Troubleshooting
- Copy as Picture is missing. Confirm that you are in the Excel desktop app and have selected worksheet cells. Expand the ribbon or click the arrow next to Copy on the Home tab. Excel for the web may not expose the same command; open the workbook in desktop Excel. On Mac, check the Home tab’s Copy menu and update the app if its ribbon differs.
- Nothing appears after pasting. Click the destination first, then use Ctrl+V on Windows or Command+V on Mac. Make sure the destination supports images and that you did not copy something else after creating the picture. Try pasting into a blank worksheet or a new Word document to determine whether the issue is the clipboard or the original destination.
- The picture is blurry or text is hard to read. Return to Excel and capture the range again using Picture rather than Bitmap, if the destination accepts it. Reduce the range, increase the source font size, or avoid enlarging the pasted object. If a particular app still renders the image poorly, try the other format choice or paste into a different app that can save or forward the image.
- The result looks different from the sheet. Reopen Copy as Picture and switch between As shown on screen and As shown when printed. Check the worksheet’s displayed formatting, page orientation, scaling, and print area if print appearance is relevant. Also verify that the selected range includes the intended cells and that no sheet formatting changed between the capture and paste.
- The image covers or shifts around cells. Remember that it floats above the grid. Drag it to an open area or resize it with a corner handle. If it obscures data, move it or paste it on a separate worksheet. Avoid placing important values directly under a picture if people will need to edit or read them.
Frequently Asked Questions
Can I paste an Excel range as an image into another worksheet?
Yes. Use Copy as Picture, click the destination worksheet, and paste. The picture sits over the cells as an object; it does not replace the underlying cell values.
Will the pasted picture update when I change the original cells?
No. Copy as Picture makes a static snapshot. If the source changes, copy the updated range again and replace the old picture. Keep the original cells if you need an editable or recalculable version.
Can I paste the image into Word or PowerPoint?
Yes. Copy the range as a picture in Excel, switch to Word or PowerPoint, and paste. Check the pasted result because available image formats and rendering can vary by destination app.
What is the difference between As shown on screen and As shown when printed?
As shown on screen captures the displayed worksheet appearance. As shown when printed aims to reflect the print-oriented layout. Choose based on where the image will be viewed, and inspect the result before sharing.
Can I do this in Excel for the web?
The browser version may not provide the same Copy as Picture command as desktop Excel. If the option is missing, open the workbook in Excel for Microsoft 365 on Windows or Excel for Mac and use its Copy as Picture menu.
Related
- Enable Editing in Excel: Exit Protected View
- How to Close an Excel Sheet With the Keyboard Quickly
- How to Close an Open Dialog Box in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Subtotal Excel Shortcut: Open the Subtotal DialogIn Excel for Microsoft 365 on Windows, press Alt+A, B in sequence to open the Subtotal dialog. It…
- Meal Planner Excel Spreadsheet: Plan a Week of MealsYes. A meal planner Excel spreadsheet can organize a week’s meals, servings, prep time, and grocery needs in…
- How to Archive Emails in Outlook Desktop (Windows)To archive email in Outlook desktop, select one or more messages and choose Archive on the Home ribbon…
- Excel To-Do List Examples and Simple TemplatesExcel to-do list examples range from a simple personal checklist to a project tracker with owners, priorities, due…
- Clear Cache in the New Outlook App on WindowsTo clear the cache in the new Outlook app for Windows, close Outlook, then use Windows Settings to…
- How to Color Every Other Row in Excel AutomaticallyTo color every other row in Excel, select your data and choose Home > Format as Table for…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.