×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Paste Options Default Change

Paste Options Default Change

Paste Options Default Change

(OP)
Excel 2003
I've got Tools|Options|Edit|"Show Paste Options buttons" set to ON.

When I paste text, I'm presented with a choice of
"Keep Source Formatting" or "Use Destination Formatting".

When the text comes from outside Excel, the buttons default to "Keep Source..".

Is there a way to change that behavior, i.e., make it default to "Use Destination.."  ?


 

Mike Halloran
Pembroke Pines, FL, USA

RE: Paste Options Default Change

Mike,
I've found that set-up preferences in programs like Excel are a highly personal thing.  That said, here's what works for me - you may be able to find a different/better way...

I personally like to keep the "show Paste Options button" turned off, because I find it anoying most of the time.  I also prefer the keyboard to the mouse, so I use a lot of keyboard shortcuts.

When I want to paste outside text (say highly formatted text from a web page) into Excel and have it look like the rest of my sheet, I will {Ctrl+c} it from the source, and then {Alt+e+s+t} it into Excel.


You've probably already found Microsoft's dissertation on "Paste Options", but if not, here it is:
http://support.microsoft.com/default.aspx?SCID=kb;en-us;291358
It doesn't seem to speak to the issue of changing the defaults in the Paste Options dialog box, though.
Perhaps you could pose the question on the MrExcel forum.

RE: Paste Options Default Change

(OP)
Thanks for the response.

Mike Halloran
Pembroke Pines, FL, USA

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources