Written by Allen Wyatt (last updated December 26, 2020)
This tip applies to Word 2007, 2010, 2013, 2016, 2019, and Word in Microsoft 365
Kat has an Excel table in her Word document, pasted as "linked with destination formatting." She wants to control the formatting and borders within Word. If she sets the formatting of the borders and later uses F9 to update the linked data in the table, the borders revert to a simple grid. These borders do not match the borders drawn in Excel or the borders that Kat set in Word. She wonders if there is a way to make Word maintain the borders as she formatted them whenever she updates the data.
The behavior that Kat describes seems to be the way that Word works when you update linked Excel data. If you manually format the linked data, all your formatting is stripped when you update the data.
There is one way around the problem—use table styles. From testing, these do not seem to be removed during the update. You can find these styles by placing the insertion point inside the linked data (in your Word document) and then displaying the Table Design tab of the ribbon. You can use one of the pre-defined table styles, or you can create your own. (Right-click in the existing styles and choose New Table Style from the resulting Context menu.)
Once you've applied the table style (or created a new one and applied that), you can update your table and the formatting should remain as specified in the style.
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (13815) applies to Microsoft Word 2007, 2010, 2013, 2016, 2019, and Word in Microsoft 365.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
Word and Excel usually work pretty well together. This means that you can easily paste charts from Excel into your Word ...
Discover MoreWord and Excel are both integral parts of Microsoft's Office suite of applications. As such, Word allows you to embed ...
Discover MoreCreating a PDF file from a Word document is easier than it used to be. Getting that PDF to contain exactly what you want ...
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.
Visit the WordTips channel on YouTube
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments