I have set mine to run on keypress CTRL + p (lower case). => Your cell(s) will be pasted exactly as copied, but the formatting will be the destination cell(s) format.ī) Setup this little macro to run in your Personal.XLSB workbook macros. (see the popup Paste Special box, and leave your mouse alone!)
Paste Format (option-command-V) will apply those format settings to the target cell without changing the cells. Format includes font, style, size, colour, and any colour fill that has been applied to the copied cell. Enough ranting.Ī) Excel 2003 (I think) but certainly 2007 - Use the useful but more laborious The only available option with Copy is to copy only the Format (option-comand-C).
The puzzle for most of us who have used Excel since the early 90's is that this has not become a standard option. Literally save dozens of hours per year per user where we could set up Excel or Word defaults for these most simple commands to SUIT US! But they think we are too dumb (maybe they don't care?) or is it that they don't actually test the system on users like And, no Microsoft, we don't work dumber as we get older, we get smarter and faster and you should respect that and allow us to set up our shortcut maps within the program instead of having to mess about recording macros please. This is an area that Microsoft could really pull some value from Excel on our behalf! It would please the thousands of users who have been trying to find a simple way to do Match Destination Format to save them a lot of time when transferring date from
