MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copying font attributes in a formula


Posted by Todd on January 18, 2002 12:32 PM

Has anyone discovered a way to copy not just the contents of a cell but the font attributes of that text as well?

I need to have a cell on one sheet automatically mirror a cell from another sheet.


Posted by val on January 18, 2002 1:02 PM

Use Format Painter to copy any formatting from one cell to another...

-Click on cell(s) with format that you want to copy

-Click on the Format Painter (little paintbrush in your toolbar)

-Click on the cell(s) that you want to copy the format to...

~Val

Posted by Todd on January 21, 2002 7:43 AM

Posted by Todd on January 21, 2002 7:47 AM

Sorry, I don't think I explained my problem correctly.
I don't want to know how to copy the formatting and contents manually but rather I a cell on one sheet to exactly mirror a cell on another sheet "automatically". In other words when I type something into "sheet1!A1" and change part of it to bold or manipulate the font size I want "sheet2!A20" to look exactly the same.