View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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.