XL2000: Cell Fill Color Bleeds into Adjacent Cells When Viewed in Web Browser

ID: Q212746

The information in this article applies to:

Microsoft Excel 2000

SYMPTOMS

When you format a block of cells with one fill color, that fill color may "bleed" into adjacent cells when you view the worksheet in a Web browser. That is, adjacent cells may also display the fill color if they did not have a predefined fill color.

CAUSE

This problem is caused by a limitation of the HTML that Microsoft 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.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: XL2000 spills spill over spillover

Keywords : kbdta xlui xlformat
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug