Can I change the default paste options?

G

Guest

I'm using Microsoft Excell 2003 from Office 2003 Professional. What I'm
trying to do is copy and paste numbers from a statistics table online into my
open workbook. Now I can enable and disable the "paste options" button that
appears when I paste the number. from the button the options are to "Keep
source formatting" or "Match Destination Formatting". The default is to "keep
source formatting" and that wont show up in the workbook correctly. What I
want to know is can I change any options so that no matter what I copy and
paste it will match the formatting of my workbook by default and give me the
choice to keep source formatting as an option instead of vis-versa.
 
N

Nick Hodge

Charlie

You cannot add to the smart tags options or alter the default. At least
through the User Interface or VBA

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

paste options - set default to match destination formatting 1
Possible to set "match destination format" as default in paste? 1
How do I set the default paste option to "Match Destination Format 1
How can I hide a paste button that appears? 1
copy and paste 4
Paste Values and Source Formatting Shortcut 3
I want paste / fill to NOT copy cell formatting 3
Paste not working correctly in MS Excel '07 3

Top