Microsoft KB Archive/212746

= Cell fill color bleeds into adjacent cells in Excel when the file is viewed in Web browser =

Article ID: 212746

Article Last Modified on 5/18/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q212746



SYMPTOMS
When you format a column to the end with one fill color in Microsoft Excel, but some cells above the fill have no background, and then you save the file as a Web page, the fill color will show behind data in the unformatted cells.



CAUSE
This problem is caused by a limitation of the HTML that Excel writes out.



WORKAROUND
To work around this problem, use any of the following methods.

Method 2: Format any cells with data with a white fill color
To do this, follow these steps:
 * 1) Select the cell(s) you want to have a white fill color.
 * 2) On the Format menu, click Cells.
 * 3) On the Patterns tab, click the white color from the Color palette and click OK.

Method 3: Define the default style for unformatted cells
Define the default style for unformatted cells to have a background fill color of white. To do this, follow these steps:
 * 1) On the Format menu, click Style.
 * 2) In the Style dialog box, click Modify.
 * 3) On the Patterns tab, click the white color on the Color palette, and click OK twice.

Additional query words: XL2000 spills spill over spillover xl2002 XL2007 XL2003

Keywords: kbpending kbprb KB212746

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.