Shading Color Above Table in HTML

In the HTML, you may notice small colored cells above a table; the color is also visible in Word when zoomed in.



This effect is coming from the linked Excel table, which contains shading color in the first row with no merged cells.



Table CrossLinks in DM Word have a small, unmerged row added at the top of each table; cell shading in the first unmerged row in Excel is reflected in this added row.

Removing the Shading Color

There are several ways to remove this color:

  1. Remove the shading color from the first unmerged row in Excel, then update the link. If the color is used to indicate values which are not finalized, this may happen naturally over time.
  2. If the table is set to Destination formatting, you follow step 1 and then update the table on Source formatting.
  3. Alternatively, for tables set to Destination, the color can be removed manually. Click in the cell below the one you want to change, then press the up arrow on the keyboard to move into the shaded cell. On the Home ribbon, click Shading No Color.

  4. To prevent the issue or remove it permanently, adding a small row at the top of each named range which contains no merged cells. This will keep any shading color from being reflected in the top rows of your table.
  5. Once you clear the shading color, run the HTML preview again.
  6. If these steps do not resolve the issue, see also Highlight Above Table in HTML.