Written by Allen Wyatt (last updated January 17, 2025)
This tip applies to Word 2007, 2010, 2013, 2016, 2019, and 2021
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 2021.
Discover the Power of Microsoft Office This beginner-friendly guide reveals the expert tips and strategies you need to skyrocket your productivity and use Office 365 like a pro. Mastering software like Word, Excel, and PowerPoint is essential to be more efficient and advance your career. Simple lessons guide you through every step, providing the knowledge you need to get started. Check out Microsoft Office 365 For Beginners today!
Word and Excel are both programs within the Microsoft Office suite. If you use both of these programs often, you may ...
Discover MoreWord makes it easy to establish links between documents. If you need to change the locations for a lot of links at once, ...
Discover MoreOver the decades, Word has always had a rather tenuous relationship with PDF files. Echoes and evidences of this tenuous ...
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