Paste Special - Borders, Gridlines, Comments using Enhanced Metafiles

sully82

New Member
Joined
Aug 11, 2009
Messages
1
In Excel 2007, when I select a range of cells (typically outlined by the print range, in print view mode) and paste into Word as an enhanced metafile, the picture is bordered in blue (from the print range). How do i keep the blue border from appearing?

Additionally, when pasting as enhanced metafile, the red flag of any comments in the selected cell range is also visible on the pasted picture. How do I make the red flag invisible?

Finally, in 2003, blue font (inputs) would automatically switch to black when pasted as a picture, but doesn't in 2007. How do I get this back?

Excel 2003 recognized that people wouldnt want to see the print border, the comment flags, the gridlines, etc. in pasted pictures in Word.

Any help would be greatly appreciated.
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Forum statistics

Threads
1,214,825
Messages
6,121,787
Members
449,049
Latest member
greyangel23

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top