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
2 comments:
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.
thanks! helped a lot!
Post a Comment