Microsoft KB Archive/104306
XL4: Cell Pattern Format Not Copied to Inserted Cell
The information in this article applies to:
- Microsoft Excel for Windows, versions 4.0, 4.0a
- Microsoft Excel for the Macintosh, version 4.0
In Microsoft Excel version 4.0, when you insert a cell, row, the pattern format is not copied from an adjacent cell if the new cell is inserted between two cells that contain different pattern formatting.
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel version 5.0.
In Microsoft Excel, when you insert a cell, row, or column, all cell formats are copied from the cell above the inserted cell (when you are shifting cells down or inserting a row) or to the left of the inserted cell (when you are shifting cells right or inserting a column).
The exception to this rule is the behavior described above; cell pattern formatting may not be copied to inserted cells in Microsoft Excel version 4.0.
"Microsoft Excel User's Guide 1," version 4.0, page 197
"Microsoft Excel User's Guide," version 5.0, Chapter 11
Additional query words: 4.00a XL4
Keywords : xlformat
Version : WINDOWS:4.0,4.0a; MACINTOSH:4.0
Platform : MACINTOSH WINDOWS
Issue type :
Last Reviewed: April 7, 1999