Microsoft KB Archive/104306

From BetaArchive Wiki

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
Issue type :
Technology :

Last Reviewed: April 7, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.