If you need to display data from an Excel sheet in your Word document, don’t waste time trying to recreate it. We’ll show you how to use live Excel data in your Word document in just a few clicks.
If you regularly use both Excel and Word, manually copying and updating tables between the two can quickly become frustrating. Fortunately, Microsoft Office includes a simple feature that allows you to insert live Excel data directly into a Word document. Even better, the data stays connected, so any changes made in Excel automatically update in Word. This is perfect for:
- Reports
- Financial documents
- Dashboards
- Project updates
- Business presentations
Why Use a Live Excel Link in Word?
Instead of recreating tables or repeatedly copying and pasting updated information, a live link creates a dynamic connection between your Excel spreadsheet and Word document. That means:
- Edit the spreadsheet once
- Watch the Word document update automatically
- Save time and reduce errors
How to Insert Live Excel Data into Word
Creating a live link only takes a few steps.
Step 1: Copy Your Excel Data – Open your Excel workbook and highlight the exact cells you want to display in Word. Then:
- Right-click and select Copy
- Or press Ctrl + C
Step 2: Open Your Word Document – Switch to your Word document and click where you want the Excel data to appear. Make sure your cursor is positioned exactly where the linked table should be inserted.
Step 3: Open Paste Special – In Word:
- Go to the Home tab
- Click the drop-down arrow under the Paste button
- Select Paste Special
A dialog box will appear with several paste options.
Step 4: Create the Live Link – Inside the Paste Special window:
- Select the Paste link option
- Choose Microsoft Excel Worksheet Object
- Click OK
Your Excel data will now appear inside Word as a linked object. Any future updates made in Excel can automatically sync with the Word document!
Additional Tips for Better Formatting
Match Word’s Formatting Style – If you prefer the table to match Word’s default fonts and formatting instead of Excel’s appearance, choose:
- Formatted Text (RTF), or
- Unformatted Text
These options are also available in the Paste Special dialog box.
Manually Update the Linked Data – Most linked Excel tables update automatically when the Word document is opened. However, if the data does not refresh right away, you can manually update it. To force an update:
- Right-click the linked table and select Update Link
- Or press F9 on your keyboard
Final Thoughts
Linking Excel data to Word is one of the easiest ways to keep reports, documents, and presentations accurate without repeated manual updates. By using the Paste Special feature, you can create dynamic documents that stay synchronized with your spreadsheets automatically.
If you frequently work with data-driven documents, this simple trick can save you hours of repetitive work while keeping your information consistent and up to date.
We regularly update the Tech Tips with new articles and advice from the IT West team so be sure to check back for the latest technical tips, tricks and guidance from our team of business IT experts.