There is not such a switch. However, you can create a macro to accomplish
From Excel, hit ALT + F11. This will open the VB Editor. In the editor go
to the Insert menu and select Module. Put the following code into the new
Close the VB Editor and go to Tools --> Macro --> Macros. In the Macros
dialog box, make sure the PlainPaste macro is highlighted and hit the
"Options" button on the right. You can specify the hot key (I have mine set
to CTRL + e) here. Hit OK, then close the Macros dialog.
Last step, go to Tools --> Options and click on the
Security tab. Click on
the "Macro Security" button at the bottom and set your security to "Medium".
Hit OK, and OK, and you're done!
From then on, whenever you are in that particular Excel document, hitting
CTRL + E (or whatever your hotkey is) will paste the contents of the
clipboard...MINUS formatting information.
Note that this will ONLY affect text. In addition, if you are copying
another Excel worksheet, this macro will only work if you are copying one
cell at a time.
"Frank Kabel" wrote:
> AFAIK there's no such switch :-)
> Frank Kabel
> Frankfurt, Germany
> "russweb" > schrieb im Newsbeitrag
> news > Thanks Frank
> > Unfortunately I am pasting alot of different items via the clipboard.
> > Perhaps there is a way of switching 'match destination formatting' on
> as the
> > default?
> > Russell
> > "Frank Kabel" wrote:
> > > Hi
> > > have you tried using 'Edit - Paste Special - Text only'
> > >
> > > --
> > > Regards
> > > Frank Kabel
> > > Frankfurt, Germany
> > >
> > > "russweb" > schrieb im
> > > ...
> > > > When I paste from word, I lose left border of cells into which I
> > > paste. As
> > > > this is invoice, causes alot of time, then reformatting cells.
> > > >
> > > > All help appreciated
> > >
> > >