Works 6: Format Is Not Retained in Spreadsheet Document (268188)


The information in this article applies to:

  • Microsoft Works 6
  • Microsoft Works Suite 2001
This article was previously published under Q268188

SYMPTOMS

When you format an entire row or column in a Microsoft Works Spreadsheet document, and you then copy and paste the formatted row or column to another section of the document or to a new document, the format of the row or column may not be retained.

CAUSE

This behavior can occur if the row or column that you are copying and pasting contains no data.

NOTE: If any cell in the row or column has contained data and the data has been deleted, the cell "behaves" as if it contains data and retains its format.

RESOLUTION

To work around this behavior, follow these steps:
  1. Type some text into any cell within the formatted row or column.
  2. Select the cell that contains the text, and then press DELETE to delete the cell contents.

    NOTE: It is not necessary to delete the cell contents unless you want to copy and paste only the format of the row or column. You can now copy and paste the row or column and retain the format.
Modification Type:MajorLast Reviewed:10/7/2003
Keywords:kbbug kbgraphic kbpending KB268188
©2003 Microsoft Corporation. All rights reserved.