Microsoft KB Archive/88852

{|
 * width="100%"|

Excel: Borders Lost When Publishing Single Cell to Word

 * }

-

The information in this article applies to:


 * Microsoft Excel for the Macintosh, version 4.0

-

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 :

Technology :