Office Compatibility Issues

Fix Missing Copy and Paste as Picture Option in Excel

Kushani NimanthikaKushani Nimanthika Nov 10, 2026 869 views

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.

How to Fix the Missing Copy as Picture Option in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Open in Desktop App

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'.

2
Select the Data

In the Excel desktop application, highlight the range of cells, charts, or objects that you want to copy as an image.

3
Use Copy as Picture

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.

4
Choose Format and Paste

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.

Switch from Excel for the Web to the Desktop Application
Web Limitation: The #VALUE! error you are seeing is directly caused by the browser version failing to interpret the copied visual elements correctly.
Seamless Spreadsheet Solution

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. 1. Open the File in WPS Spreadsheet: Launch WPS Office on your computer and open your spreadsheet document.
  2. 2. Select the Target Cells: Highlight the specific range of cells or charts you want to capture as an image.
  3. 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. 4. Paste the Image: Press Ctrl+V or right-click and select 'Paste' to place your high-quality picture exactly where you need it.
Fully compatible with Microsoft Excel (.xlsx) files.Built-in 'Copy as Picture' and 'Camera' tools for instant image capture.Free desktop application with no web-only clipboard restrictions.Lightweight and fast to launch on both Windows and Mac.
microsoft office alternative - wps office

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.