Excel 2003-paste

L

Libby

Does anyone know if there is a way to make the paste function ALWAYS match
the destination formattting?
 
D

David McRitchie

To use the destination formatting paste values.
Edit, paste special, values

There is a toolbar icon that you can install:
customize, commands, edit, paste values
and you might also be interested in installing
customize, commands, edit, paste formats (same results as using format painter)

You can create a macro and assign it a shortcut key
http://www.mvps.org/dmcritchie/excel/shortx2k.htm#mykeys
 
D

David McRitchie

Installing the "paste value" into your toolbars through customize
is one place, you can also install it into your Edit menu through customize

To get to customize right click anywhere in menu or toolbars,
or start at Tools, customize
 
Top