Copy Cell atributes to another
 

I would like to know of there is a way to copy one cell atributes to another.

Example:

Sheet 1 / A1 = James (Font Red/Bold, Highlighted Yellow)

I want to copy the exact cell with all it's properties to another sheet.

Sheet 2 / A1

Also, when I change the cell. If I change 'James' to 'Bill' or change the
font Color and Face to something else, or Change the Highlighted color; the
corisponding cell will also change to exactly what you changed on the A1 cell.

Copy Cell atributes to another
 

Use Edit Copy / Paste

This will copy the cell with all attributes. But if you later change the
formatting of the source cell, you will have to re-copy.
--
Gary''s Student - gsnu200801


"Matlock" wrote:

I would like to know of there is a way to copy one cell atributes to another.

Example:

Sheet 1 / A1 = James (Font Red/Bold, Highlighted Yellow)

I want to copy the exact cell with all it's properties to another sheet.

Sheet 2 / A1

Also, when I change the cell. If I change 'James' to 'Bill' or change the
font Color and Face to something else, or Change the Highlighted color; the
corisponding cell will also change to exactly what you changed on the A1 cell.

Copy Cell atributes to another
 

I think what you want is a way to ensure that no matter what is in cell A1,
it will also be in another cell.

Use Copy Special, then Paste Link to the new cell.

"Matlock" wrote:

I would like to know of there is a way to copy one cell atributes to another.

Example:

Sheet 1 / A1 = James (Font Red/Bold, Highlighted Yellow)

I want to copy the exact cell with all it's properties to another sheet.

Sheet 2 / A1

Also, when I change the cell. If I change 'James' to 'Bill' or change the
font Color and Face to something else, or Change the Highlighted color; the
corisponding cell will also change to exactly what you changed on the A1 cell.

Copy Cell atributes to another
 

Paste link will link the data, not the formatting.


Gord Dibben MS Excel MVP

On Wed, 20 Aug 2008 09:23:01 -0700, Steven
wrote:

I think what you want is a way to ensure that no matter what is in cell A1,
it will also be in another cell.

Use Copy Special, then Paste Link to the new cell.

"Matlock" wrote:

I would like to know of there is a way to copy one cell atributes to another.

Example:

Sheet 1 / A1 = James (Font Red/Bold, Highlighted Yellow)

I want to copy the exact cell with all it's properties to another sheet.

Sheet 2 / A1

Also, when I change the cell. If I change 'James' to 'Bill' or change the
font Color and Face to something else, or Change the Highlighted color; the
corisponding cell will also change to exactly what you changed on the A1 cell.