Shift-Copy - Copy Picture - how to do this in Excel 2007?

[bungaree]

Hello forum,

Please can someone advise on how to take a pic of your selection in a spreadsheet in Excel 2007 to the clipboard?

Previous versions you just hold down the shift key while hitting copy - can't make it work in 2007!

Many thanks
Bungaree

[nattasiray]

Select Range
At Home tab > Clipboard Group > Click Arrow button on Paste button Choose As Picture > Copy as Picture
Choose option on copy picture.
At Home tab > Clipboard Group > click Arrow button on Paste button Choose As Picture > Paste as Picture

[bungaree]

Thank you so much! What a convoluted way of getting there - can't say I'm enamoured with 2007.....

Much appreciated,
Bungaree

[lemerson]

Thanks for this tip, it really helped me.

Who would have guessed the "Copy Picture" option would be under the PASTE menu!