Excel >> Keeping Source Formatting with Paste Link and VLOOKUP

by bnJlaG1hbg » Thu, 06 Oct 2005 23:21:05 GMT

I am creating a paste link from worksheet A to worksheet B. The cell on
worksheet A is formatted with one word in regular arial font and the second
word in italics. Is there a way to keep this formatting in a paste link at
the destination (worksheet B)? So far, I have tried the paste link and
immediately followed with the paste special format, but this has had no
effect. Likewise, I am attempting the same exercise with VLOOKUP.

Would anyone have a solution?


Excel >> Keeping Source Formatting with Paste Link and VLOOKUP

by Dave Peterson » Fri, 07 Oct 2005 01:39:25 GMT

First, formulas can return values--they can't change formats.

And second, excel doesn't support that kind of formatting (character by
character) with formulas.


Dave Peterson

Similar Threads

1. XL2003 Paste not keeping link to source spreadsheet - Excel

2. keep source formatting is not an option in paste option button

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?


3. Always keeping source formatting when copying and pasting in Excel - Excel Functions&Formulas

4. Setting the paste option "Keep Source Formatting" as default

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.

5. Linking Cells -- Keep Source Cell's Formatting - Excel

6. how do I paste links and keep formats

when I copy using the paste links function I lose the format.  How do I paste 
links and keep the format?

7. How too keep format when using paste link? - Excel

8. cut/copy & paste w/source formatting except for conditional 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.

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!