Excel: Borders Lost When Publishing Single Cell to Word

ID: Q88852

The information in this article applies to:

SUMMARY

Single cells published from within Excel 4.0 appear without borders when subscribed to within Microsoft Word version 5.0. In order to create borders in this situation, a single-cell table must be created from the subscribed text and borders applied to it within Microsoft Word.


MORE INFORMATION

When subscribing to a single cell published from Excel version 4.0, Microsoft Word version 5.0 does not create a table to hold the edition information. One result of this is that borders in the published cell are not automatically recreated within Microsoft Word. The solution is to create a single-cell table from the subscribed information and apply the appropriate borders to the table within Microsoft Word.

In order to create a table from a single cell within Microsoft Word:

  1. Select the subscribed text within Microsoft Word.


  2. From the Insert menu, choose Text To Table.


  3. Enter an appropriate width for the table cell (the default is 6 inches.)


  4. Choose the OK button.


To apply border information to a table within Microsoft Word:

  1. Click anywhere within the table's contents.


  2. From the Format menu, choose Border.


  3. Select an appropriate line style from the Line section.


  4. Click the appropriate sides that should display a border in the Border section.


  5. Choose the OK button.


Additional query words: 4.00 publish subscribe lost format formatting 


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 26, 1999