XL2000: Formats May Not Be Applied to Pasted Merged Cell (211462)
The information in this article applies to:
This article was previously published under Q211462 SYMPTOMS
When you copy a merged cell and paste it, Microsoft Excel 2000 fails to apply the formatting of the original merged cell to the merged cell you pasted.
CAUSE
This problem occurs when the following conditions are true:
- You copy one merged cell, and then paste it into another merged
cell.
-and-
- The two merged cells are different sizes.
NOTE: This problem does not occur when you copy a merged cell and paste it in a single, unmerged cell or in another merged cell that is exactly the same size as the cell you copied.
WORKAROUND
To work around this problem, follow these steps:
- Click the first merged cell. On the Format menu, click Cells.
- Click each tab that contains formatting that is applied to the cell, and change the value of one option on the tab; then, reset the option to the original setting. For example, if the Strikethrough check box has been selected on the Font tab, click to clear the Strikethrough check box, and click again to select the check box.
NOTE: If the cell contains more than one type of formatting, perform these steps for each tab that contains the formatting options you selected. - Click OK.
- Click the second merged cell.
- On the Edit menu, click Repeat Format Cells.
The result is that the second merged cell is formatted exactly as the first
merged cell.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type: | Major | Last Reviewed: | 11/5/2003 |
---|
Keywords: | kbbug kberrmsg kbpending KB211462 |
---|
|