paste options - set default to match destination formatting

[Amy]

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

 

[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)