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 1: Do not format any unnecessary or unused cells
Method 2: Format any cells with data with a white fill color
To do this, follow these steps:
- Select the cell(s) you want to have a white fill color.
- On the Format menu, click Cells.
- 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:
- On the Format menu, click Style.
- In the Style dialog box, click Modify.
- 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
