When I do 'paste special', 'paste link' the formatting doesn't transfer with
it. I want the fomatting to transfer with it.

Cannot be done.

Do a second pass and select "Formats"

i.e. paste specialpaste link

then

paste specialformats


Gord Dibben MS Excel MVP

On Tue, 24 Jul 2007 14:02:02 -0700, jrebello
wrote:

When I do 'paste special', 'paste link' the formatting doesn't transfer with
it. I want the fomatting to transfer with it.

Hi,

Note: You cannot copy both the cell value and the cell format when
performing Paste Special command on the Edit menu. To must do as two seperate
function.

Do the following:

1. Click to select the cell.
2. On the Edit menu, click Copy.
3. Select a differnt cell location.
4. On the Edit menu, click Paste special. The Paste Special dialog is
displayed.
5. Under Paste section click All option.
6. Click Paste Link button. The copies cell has the absolute cell address of
the source location.
7. Click the source cell and click the Format Painter icon on the Standard
Toolbar.
8. Click the Target cell location and click to apply the format to the cell.


Challa Prabhu.


"jrebello" wrote:

When I do 'paste special', 'paste link' the formatting doesn't transfer with
it. I want the fomatting to transfer with it.