You can control which attributes of a cell are copied by using the Copy Options dialog of the Options menu (Figure 5.5). This dialog contains settings which determine which of the attributes are copied with the Copy Values and Copy Formulas operations. They are not used by the Selection-Paste operation used for copying with just the mouse.
Figure 5.5: Copy Options Dialog Box