Excel - How to Match Destination Format always

[Socalgal]

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]

No way to accomplish this? :/

[vass0922]

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]

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]

does this do it?

Topics: Turning Off Paste Options

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]

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]

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]

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

Thats not exactly removing a step though :-/

[Socalgal]

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