Pasting a Selection as a Picture

carlsondaniel · External Since: Sep 30, 2006 Posts: 5

Hello, I am trying to convert a selection in Excel into a picture
within Excel. Whenever I select the cells I want to copy and go to
"Paste Special" it gives me only Paste Special with only the selections
for "All", "Formulas", "Values", etc...

I need the Paste Special that will allow me to paste as a picture.
Currently I make my selection in Excel, select Copy, and then do a
Paste Special in Word and then import back into Excel. Is there a
simpler way? Thanks for the feedback and support.

macropod · External Since: Sep 27, 2005 Posts: 994

Hi Daniel,

After copying:
.. select the destination cell
.. hold down the <Shift> key and click on the 'Edit' menu
.. choose 'Paste Picture

Cheers
--
macropod
[MVP - Microsoft Word]

<carlsondaniel DeleteThis @gmail.com> wrote in message
news:1169751797.800738.270700@s48g2000cws.googlegroups.com...
| Hello, I am trying to convert a selection in Excel into a picture
| within Excel. Whenever I select the cells I want to copy and go to
| "Paste Special" it gives me only Paste Special with only the selections
| for "All", "Formulas", "Values", etc...
|
| I need the Paste Special that will allow me to paste as a picture.
| Currently I make my selection in Excel, select Copy, and then do a
| Paste Special in Word and then import back into Excel. Is there a
| simpler way? Thanks for the feedback and support.
|

vitruvian · External Since: Feb 06, 2007 Posts: 9

On Jan 26, 6:03 am, "carlsondan...@gmail.com"
<carlsondan... DeleteThis @gmail.com> wrote:
> Hello, I am trying to convert a selection in Excel into a picture
> within Excel. Whenever I select the cells I want to copy and go to
> "Paste Special" it gives me only Paste Special with only the selections
> for "All", "Formulas", "Values", etc...
>
> I need the Paste Special that will allow me to paste as a picture.
> Currently I make my selection in Excel, select Copy, and then do a
> Paste Special in Word and then import back into Excel. Is there a
> simpler way? Thanks for the feedback and support.

Ok, this is a little complicated, so feel free to email me if unclear
ok...

First... Open Excel, and right click on any toolbar, and select
customise, you should be on the commands tab, if not please select it
Then select Tools on the left, and scroll down until you find the one
called "Camera" and has a little camera icon (it's a little over half
way down)... Drag and drop this back to the tool bar

Now go to the work sheet and select the cells that you want to copy...
then click the camera and then anywhere else on the worksheet, hold
click drag and release... You should now have a picture perfect image
of what you want...

Two things you should know...

1) This will always update the image depending on the cells (try it,
it's really funky to see)
2) If you need to take it to a word document or powerpoint or
something, you will need to cut and paste it, but it always comes out
perfect (but this fix it to a static picture file and not dynamic like
the first one)

Hope this helps you

macropod · External Since: Sep 27, 2005 Posts: 994

Hi vitruvian,

The method I described allows you to paste the picture as a link also.

As for other apps (eg Word), you can paste the range in various formats, including as a picture or worksheet object, via Edit|Paste
Special, with or without a link to the source.

Cheers

--
macropod
[MVP - Microsoft Word]

<vitruvian.DeleteThis@optusnet.com.au> wrote in message news:1170763731.777707.274770@j27g2000cwj.googlegroups.com...
| On Jan 26, 6:03 am, "carlsondan...@gmail.com"
| <carlsondan....DeleteThis@gmail.com> wrote:
| > Hello, I am trying to convert a selection in Excel into a picture
| > within Excel. Whenever I select the cells I want to copy and go to
| > "Paste Special" it gives me only Paste Special with only the selections
| > for "All", "Formulas", "Values", etc...
| >
| > I need the Paste Special that will allow me to paste as a picture.
| > Currently I make my selection in Excel, select Copy, and then do a
| > Paste Special in Word and then import back into Excel. Is there a
| > simpler way? Thanks for the feedback and support.
|
| Ok, this is a little complicated, so feel free to email me if unclear
| ok...
|
| First... Open Excel, and right click on any toolbar, and select
| customise, you should be on the commands tab, if not please select it
| Then select Tools on the left, and scroll down until you find the one
| called "Camera" and has a little camera icon (it's a little over half
| way down)... Drag and drop this back to the tool bar
|
| Now go to the work sheet and select the cells that you want to copy...
| then click the camera and then anywhere else on the worksheet, hold
| click drag and release... You should now have a picture perfect image
| of what you want...
|
| Two things you should know...
|
| 1) This will always update the image depending on the cells (try it,
| it's really funky to see)
| 2) If you need to take it to a word document or powerpoint or
| something, you will need to cut and paste it, but it always comes out
| perfect (but this fix it to a static picture file and not dynamic like
| the first one)
|
| Hope this helps you
|