Excel: Borders Lost When Publishing Single Cell to Word

Last reviewed: November 29, 1994
Article ID: Q88852
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.


KBCategory: kbinterop
KBSubcategory:

Additional reference words: 4.00 publish subscribe lost format
formatting


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.