paste options - set default to match destination formatting

G

Guest

Hi,
Is it possible to set the default paste option to "match destination
formatting" so I don't have to go through paste options each time?

Same with using autofill - can I set the default to "fill without formatting"?

Also, occasionally the paste options don't come up properly - after I paste
something the paste options icon pops up but the arrow next to it isn't there
and I can't click on it to access the paste options. This only happens
occasionally and seems to usually happen when the pasted section is next to
the edge of the screen.

Thanks,
Amy
 
N

Nick Hodge

Amy

You cannot change the default smart tag options.

On your last one it could possibly be a frozen pane issue (Window>(Un)freeze
panes)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 

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

How to set a default paste option of "Match Destination Format" 1
Possible to set "match destination format" as default in paste? 1
Can I change the default paste options? 1
Automatically match destination formatting? 3
Make "Match Destination Format" the default 3
How do I set the default paste option to "Match Destination Format 1
I want paste / fill to NOT copy cell formatting 3
Urgent - Pasting options are not displaying 1

Top