Fix Missing Copy and Paste as Picture Option in Excel
Question details
The user cannot find the 'Copy as Picture' option in Excel, and attempting to copy data often results in pasted plain text or a #VALUE! error.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Trying to copy a range of cells, a chart, or an object as an image.
- Observed behavior
- The 'Copy as Picture' feature is entirely missing from the interface, and standard copying pastes as text or produces a #VALUE! error instead of an image.
Verify whether you are using Excel for the web in your browser or the full Excel desktop application, as the available clipboard features differ significantly between the two platforms.
Switch from Excel for the Web to the Desktop Application
Use this solution because Excel for the web lacks the native 'Copy as Picture' tool, which causes the clipboard to default to plain text or display a #VALUE! error when pasting.
Excel for the web is a lightweight version of the software and does not support advanced clipboard image formatting. To utilize the 'Copy as Picture' feature, you must open the workbook in the full desktop version of Excel.
While viewing your file in Excel for the web, click the 'Editing' or 'Viewing' button on the top ribbon and select 'Open in Desktop App'.
In the Excel desktop application, highlight the range of cells, charts, or objects that you want to copy as an image.
Navigate to the 'Home' tab on the ribbon. Click the small drop-down arrow located right next to the 'Copy' button, and choose 'Copy as Picture' from the menu.
In the pop-up dialog, select 'As shown on screen' and choose 'Picture', then click 'OK'. You can now press Ctrl+V to paste the image into your desired application or worksheet.

Easily Copy Data as a Picture with WPS Spreadsheet
If you don't have access to the Microsoft Excel desktop app, you can use WPS Office. WPS Spreadsheet is a free, highly compatible desktop application that includes the 'Copy as Picture' feature, allowing you to bypass web-version limitations and errors instantly.
- 1. Open the File in WPS Spreadsheet: Launch WPS Office on your computer and open your spreadsheet document.
- 2. Select the Target Cells: Highlight the specific range of cells or charts you want to capture as an image.
- 3. Select Copy as Picture: Go to the 'Home' tab, click the drop-down arrow next to the 'Copy' icon, and select 'Copy as Picture'.
- 4. Paste the Image: Press Ctrl+V or right-click and select 'Paste' to place your high-quality picture exactly where you need it.

Frequently Asked Questions
Why does pasting an Excel picture result in a #VALUE! error?
This happens when copying complex data or images from Excel for the web. Because the web clipboard cannot handle advanced image formats, it converts unsupported visual elements into text strings or formula errors like #VALUE!.
Is 'Copy as Picture' available in Excel for Mac?
Yes, 'Copy as Picture' is available in the desktop version of Excel for Mac. You can find it by selecting your cells and using the 'Copy' dropdown menu on the Home tab, or by holding the Shift key and clicking the 'Edit' menu at the top to reveal the 'Copy Picture' option.
Can I use the Camera tool instead of Copy as Picture?
Yes. The Camera tool creates a dynamic, linked image of your selected cells, meaning if you update the original data, the picture updates automatically. You may need to add the Camera tool to your Quick Access Toolbar first by customizing the ribbon in the Excel desktop app.




