Monday, November 19, 2007

copy as picture from excel

Hi people.

a new trick: in excel you can copy a selection "as picture" into the clipboard. to do this, just select the table you whant to copy (or the range) and hold on shift. then click on edit (continue holding shift) and you'll see something like "picture copy" (sorry, my excel is in german, i don't know what's the name for this function in english).... there you are.

another posibility is to create a macro and give him a shortcut. put this single line in the macro:

Selection.CopyPicture Appearance:=xlPrinter, Format:=xlPicture

and that's it.

enjoy it


Anonymous said...

I used xlprinted for range. The tables look perfect on excel but when they got copied, the numbers are not shown properly; the column width seem reduced using that function. Don't have this problem if use xlscreen.

Anonymous said...

thanks! helped a lot!