 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / January 2008Excel copy and paste
I am copy and then pasting on Excel. The clip board keeps coming up every time to ask about the formatting. I want it to stay on "Match Destination format" Can anyone help me to work more efficiently? Thanks Hi Cherie - I'm not sure why you think you have a problem - the default *is* to match destination formatting:-) Just because the Paste Options Button appears when you paste doesn't mean you have to *use* it - just ignore it & it [eventually] will go away. If you want to have it not appear at all you can go into Excel> Preferences - Edit, remove the check on Show Paste Options Button. HTH |:>) Bob Jones [MVP] Office:Mac On 10/11/07 10:36 PM, in article 6464C2BC-718A-41F1-B4D4-45071D2F895B@microsoft.com, "Cherie" I am copy and then pasting on Excel. The clip board keeps coming up every time to ask about the formatting. I want it to stay on "Match Destination format" Can anyone help me to work more efficiently? Thanks I have the same problem as Cherie. The default is set to "Keep Source Formatting" and I cannot find a way to change it to "Match Destination Formatting" Some days I copy an paste hundreds of times, so it would save a huge amount of time if I didn't have to go back and fix the formatting after pasting. > Hi Cherie - > [quoted text clipped - 18 lines] > Can anyone help me to work more efficiently? > Thanks When you paste, a small clipboard icon appears at the lower right corner of the area you paste to. Click that button & you'll find the option to Match Destination Formatting. All you have to do is select Match Destination Formatting (or one of the other options) - there should be no need " ...to go back and fix the formatting after pasting". But no, you can't change the paste operation's Default behavior. However, there is a setting in Excel> Preferences> Edit labeled "Show paste options button" & if that check has been cleared the clipboard button won't show up. Also, if you paste more than will fit into your window you may not see the button as it will be outside your viewing area. In the former case you can simply restore the check. In the latter you can scroll to find the button or you can use the Edit> Paste Special - Formulas command to avoid including the pasted content's formatting. However, the Paste Special dialog can vary depending on *what* you've copied and *where* you've copied from. Even so, it should give you appropriate choices as to how you want to have the pasting handled. HTH |:>) Bob Jones [MVP] Office:Mac On 1/4/08 5:41 PM, in article 096F553C-CD25-416E-8B07-F1B238C1D36E@microsoft.com, "smccarvi" > I have the same problem as Cherie. The default is set to "Keep Source > Formatting" and I cannot find a way to change it to "Match Destination [quoted text clipped - 25 lines] >> Can anyone help me to work more efficiently? >> Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.