XL97: Pasting Merged Cells May Clear Cells in DestinationLast reviewed: January 15, 1998Article ID: Q157028 |
The information in this article applies to:
SYMPTOMSIn Microsoft Excel 97, when you copy a merged cell, select a destination cell or range of cells, and then use the Paste Special command, Microsoft Excel may paste the contents of the merged cell into a single cell in the destination range. In addition, Microsoft Excel may fail to apply the merged cell format to the destination cell range.
CAUSEThis behavior occurs when the following conditions are true:
STATUSThis behavior is by design in Microsoft Excel 97.
MORE INFORMATIONA merged cell is created by combining two or more selected cells. Microsoft Excel places the upper-leftmost data in the selected range into the resulting merged cell. The upper-left cell contains the value or formula for the merged cells. For example, if you merge cells A1:A3, A1 contains the value of the merged cell, and cells A2 and A3 are empty.
REFERENCESFor more information about merging worksheet cells, click the Index tab in Microsoft Excel 97 Help, type the following text
merging, cellsand then double-click the selected text to go to the "Merge cells to span several columns or rows" topic.
|
Additional query words: XL98 blank
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |