XL: Cell Fill Color Bleeds into Adjacent Cells When Viewed in Web Browser (212746)


The information in this article applies to:

  • Microsoft Excel 2000
  • Microsoft Excel 2002
This article was previously published under Q212746

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:
  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.
Modification Type:MajorLast Reviewed:11/3/2003
Keywords:kbpending kbprb KB212746
©2003 Microsoft Corporation. All rights reserved.