如何从单元格中复制图片并将其粘贴到桌面上 [英] how to copy a picture from a cell and paste it in desktop

问题描述

我在一个单元格中有一张图片并将其复制并粘贴到桌面上，我尝试了以下内容：



首先，我突出显示了特定的单元格。 br />
其次，我在栏中选择了'粘贴'，然后选择'作为图片'，然后'复制为图片'，在复制图片对话框中，我选择了'如屏幕所示'，格式为I选择图片并按下确定按钮，因此我将图片放在剪贴板中。好。但是如何在剪贴板中复制这张图片并将其粘贴到桌面上？

解决方案

我我很容易用嵌入的图片做这件事。步骤：

1.选择图像。

2.简单复制或复制为图片...图片现在在剪贴板中。

3.打开任何图片编辑软件（ MS Paint ， Photoshop ）并将其粘贴在那里。

注意：在 MS Paint 你可能需要裁剪图像（粘贴后：右键单击图像 - >裁剪），以便将画布调整为图像大小。

4.将图片保存为所需的格式和位置。

5.完成。

请阅读我的评论（到Solution1）！



如果您想自动执行图像复制过程，可以使用VBA [ ^ ]。您需要做的就是插入新模块 [< a href =http://msdn.microsoft.com/en-us/library/dd553655%28v=office.12%29.aspxtarget =_ blanktitle =New Window> ^ ]然后复制以下功能之一。



看看这里：

http://stackoverflow.com/questions/18232987/export-pictures-from-excel-file-into-jpg-using -vba [ ^ ]

http://snipplr.com/view/54755/ [ ^ ]

http://www.mrexcel.com/forum/excel-questions/233108-visual-basic-applications-code-export-image-file-preferable-jpg.html [ ^ ]

http://www.vbforums.com/showthread.php?538529-Export-an-Image-from-Excel-Sheet-to-Hard-Drive [ ^ ]

I have a picture in a cell and to copy it and paste it in desktop , I tried the following:

Firstly, I highlighted that particular cell.
Secondly, I selected the 'paste' in the bar and chose 'as picture' and then 'copy as picture' and in the copy picture dialog box I selected 'As shown in screen' and under format I chose 'picture' and pressed 'OK' button and as such I got the picture in the clipboard. Well. But how to copy this picture in clipboard and paste it in desktop?

解决方案

Hi,

I am doing this easily with the embedded pictures. Steps:
1. Select the image.
2. Simple Copy or Copy as Picture... The picture is in the clipboard now.
3. Open any picture editing software (MS Paint, Photoshop) and paste it there.
Note: In MS Paint you might need to crop the image (after pasting: Right Click on the image -> Crop) in order to resize the canvas to the size of the image.
4. Save the picture in desired format and location.
5. Done.

Please, read my comment (to Solution1)!

If you would like to automate the "image copy" process, you can use VBA[^]. All you need to do is to insert new module[^] and then copy one of below functions.

Have a look here:
http://stackoverflow.com/questions/18232987/export-pictures-from-excel-file-into-jpg-using-vba[^]
http://snipplr.com/view/54755/[^]
http://www.mrexcel.com/forum/excel-questions/233108-visual-basic-applications-code-export-image-file-preferably-jpg.html[^]
http://www.vbforums.com/showthread.php?538529-Export-an-Image-from-Excel-Sheet-to-Hard-Drive[^]

这篇关于如何从单元格中复制图片并将其粘贴到桌面上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！