Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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.

↑ Back to the top


Cause

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

↑ Back to the top


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.

↑ Back to the top


Keywords: KB212746, kbprb, kbpending

↑ Back to the top

Article Info
Article ID : 212746
Revision : 5
Created on : 5/18/2007
Published on : 5/18/2007
Exists online : False
Views : 514