Inheriting Cell Formatting
When formatting cells in a grid, you can inherit formatting from a cell and apply it to another cell. The following formatting options can be inherited from a cell in a grid:
-
Number
-
Alignment
-
Font
-
Borders and Shading
-
Replacement Text
To inherit cell formatting:
Note:
You can only inherit from a cell that does not have previously defined inheritance. For example, if you format column A and then inherit formatting into column B, you cannot then inherit formatting from column B into column C. You can, however, format column A, select columns B and C, and inherit formatting for column B and C from column A.
Note:
If you have inherited formatting and then modify the format of the cell to which you inherited formatting, the inheritance you established no longer applies. For example, if you inherit the font name property in cell A4 from cell B4 and you subsequently modify the font name in cell A4, the format inheritance no longer exists. This breaks the formatting link that was previously established between the two cells.