Excel - How to Match Destination Format always

**Socalgal** · July 3rd, 2008, 09:53 PM

Excel Gurus - I need you.

Pasting new data into a spreadsheet brings up the Paste Options icon to either Keep Source Formatting, or Match Destination Formatting.

How do I universally apply to the spreadsheet so that pasting new data automatically or always matches destination formatting?

Only need on a per worksheet basis (not for a default template).

Thanks!

**Socalgal** · July 5th, 2008, 05:59 PM

No way to accomplish this? :/

vass0922 · July 5th, 2008, 06:03 PM

Hmm is this Excel 2003, or 2007?

I've seen that option, and found it quite annoying
give me a bit (possibly Monday) and I'll see what I can figure out

If anybody else has ideas, send 'em

**Socalgal** · July 5th, 2008, 06:53 PM

vass

thanks - I appreciate your effort.

Excel 2003

I did find a "workaround" that involved creating a macro, but that's still a PITA to hit a button every time.. not much of an improvement.

vass0922 · July 5th, 2008, 08:31 PM

does this do it?

Topics: Turning Off Paste Options

Quote:

Choose Options from the Tools menu. Excel displays the Options dialog box.

Make sure the Edit tab is displayed. (Click here to see a related figure.)

Clear the Show Paste Options Buttons check box.

Click on OK.

**Socalgal** · July 5th, 2008, 09:16 PM

Nope :/

That only disables the Paste Options button from appearing while keeping the source formatting intact; it does not cause what I want to happen, which is to automatically *always match destination format* (i.e., without the paste option button).

Thanks, though

vass0922 · July 5th, 2008, 10:37 PM

doesn't seem to be possible

here is one option
OpenOffice.org Forum :: Paste as unformatted text by default?

Not sure if its what you're looking for though

seems to be a new feature in Excel 2007
Set your own default Paste options with Word 2007 | Microsoft Office | TechRepublic.com

vass0922 · July 5th, 2008, 10:37 PM

does Paste Special --> Values do what you want?

Thats not exactly removing a step though :-/

**Socalgal** · July 6th, 2008, 01:34 PM

thanks for the help, vass

I'll try recording a macro using Ctrl + V as the shortcut.

Yeah, how great that they have that option in 2007

Maybe I can find a TS seminar to get it gratis

spelunkr1971 · September 14th, 2008, 08:00 PM

Oh this is SOOOOOOOO frustrating....
What happened? What friggin genius (ha) thought this would be a good idea?