Paste Value only

V

vbarookie

When I paste text (of a different format) into a cell with a different
format, a small Paste Option icon appears on the bottom right hand
corner of the pasted cell. There are two options in this Paste Option
icon: "Keep Source Formatting" and "Match Destination Formatting".
Since "Keep Source Formatting" is the selected option, is there a way
to set "Match Destination Formatting" as the default choice? - this
will eliminate one more step for my end users to prevent blowing away
the cell format. Or there is a cleverer way to solve this? Thanks in
advance. :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paragraph numbering in Word 1
Pasting from the clipboard 3
2010 Format question please 0
Paste link only - not value 4
Default Copy / Paste Mode 3
Table Preferred width is changed when pasting 1
Keyboard shortcut for the smart tag 1
pasting objects get clipboard 0

Top