ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Gridline problem pasting picture from excel (https://www.excelbanter.com/excel-discussion-misc-queries/237573-gridline-problem-pasting-picture-excel.html)

trip150

Gridline problem pasting picture from excel
 
i recently installed an office 2007 update, and now i cannot paste pictures
from excel worksheets without gridlines and comment boxes showing. In the
past, gridlines would show in excel, but when you pasted to a word document
they would go away along with red comment box markers. Now i can't get them
to go.
thanks

Bernard Liengme[_3_]

Gridline problem pasting picture from excel
 
The use of the word "picture" suggest you are using the command sequence:
Home | Paste | As Picture |Coy as Picture to make a snapshot of part of a
worksheet.

It the dialog that follows this you select either (a) As on Screen or (b)
As Printed.
The first will capture gridlines and comment markers, the second will not.
This was the same in earlier Excel versions
Let us know if this fixes your problem
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"trip150" wrote in message
...
i recently installed an office 2007 update, and now i cannot paste
pictures
from excel worksheets without gridlines and comment boxes showing. In the
past, gridlines would show in excel, but when you pasted to a word
document
they would go away along with red comment box markers. Now i can't get
them
to go.
thanks





All times are GMT +1. The time now is 03:13 AM.

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