The Answer is The Office Clipboard
Clipboard
Office Clipboard!
Use regular copy, then past only the format (paste format) to a cell.
Copy will copy the format and content of the source area and place it in what is known as the Clipboard, which is a reserved area in the computer's memory.
Usually, you would use the copy and paste options for that.
In the Clipboard group, click the Format Painter button once to turn of the command off, Alternatively, press the ESC button on you keyboard to turn off. Source: Go!Office 2007
format riport
There is not a 'source' button on computers. If there is a source button it would be on the display screen, however, that will vary by manufacturer.
When you copy the contents of a source cell into a destination cell, the existing contents of the destination cell will be replaced by the contents of the source cell. This means that any data, formulas, or formatting in the destination cell will be lost unless you have a backup or undo option available. The new contents will take the place of whatever was previously there.
directory
directory
Yes