microsoft.public.excel.misc - Excel Forums for Business Finance, Analysis and Application Development
I'm trying to paste into Excel from a web page and would like to keep the source formatting. The "keep source formatting" option button is missing. How do I get it back? Thanks! -- Tina
PowerPoint should include the ability to set any of the selections in the paste options as a default. When pasting slides, PowerPoint 2003 keeps reformatting them to the new design template formatting. I have to click on the paste option to select "Keep source formatting." I find this time consuming (translated co$tly) since I use a large number of slides in libraries to pull from and would like to set the default to Keep source formatting by default and not have to perform two extra mouse clicks with every paste. Setting the paste option defaults should probably be incorporated into the whole office suite of products, since often individuals need to perform the same repetative operations and would like it to behave the same way they choose each time. Have noticed that there are several others on the discussion group with the same dilema.
when I copy using the paste links function I lose the format. How do I paste links and keep the format?
I regularly need to cut or copy and paste from one worksheet to another and I'm having trouble with how I want it formatted. ex: T1234 22/07/09 SC 04/08/09 Norway In my workbook T1234 has a blue fill (manual) and 04/08/09 has a green fill (conditional formatting). I need to cut or copy and paste the entire row into another worksheet and keep the blue formatting from the first cell, but I don't want the conditional formatting anymore. Is there a way to do this without changing the format every time after I paste? This would be INCREDIBLY helpful! Thanks!