ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Copy As Picture (https://www.excelbanter.com/setting-up-configuration-excel/231120-copy-picture.html)

VBA dimwit

Copy As Picture
 
Does anyone know how to set the Copy as Picture default to "As Shown When
Printed". I know how to do it each time Home:Paste:As PictuCopy As
PictuAs Shown on Screen, but can that be set as a default? I often copy
tables out of Excel 2007 and paste into Word 2007, but when I do, the
gridlines and other formula warnings show up since the As Shown on Screen
setting appears to be the default. I didn't have this problem in
2003......Please Help

ebrunner

Copy As Picture
 
I have the same problem. Never had it before (even w/0ffice 2007), but over
the last few months its been

I like to copy my cells regularly (ctrl-c), then paste special (as picture)
into the word/ppt doc. The tables usually come out as printed, but now
they're coming out as a screenshot.




All times are GMT +1. The time now is 04:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com