Link A Word Document To Excel Data

BY STANLEY ZAROWIN

Key to Instructions
To help readers follow the instructions in this article, we used two different typefaces:
Boldface type is used to identify the names of icons, agendas and URLs.
Sans serif type indicates the names of files and the names of commands and instructions users should type into the computer.
  Q. I often make presentations based on last-minute sales data. It gets really wild when I have to copy last-minute numbers from the spreadsheet and quickly drop them into a Word document for the presentation. I sure hope there’s a better way.

A. There is, and it’s fast and simple. I’ll show you how to dynamically link the Excel spreadsheet to your Word document so that when you make any change in the spreadsheet it instantly and automatically will appear in the document. Caveat: Both the spreadsheet and the document must be in the same folder (subdivision).

Begin by highlighting the range of cells (A1 to D4) you want displayed in the document and copy it (Ctrl+C).

Now go to the Word document, place your cursor where you want the copied cells to go and click on Edit, Paste Special. When the Paste Special dialog box opens, select the radio button labeled Paste link , click on Microsoft Excel Worksheet Object and on OK .

Now any changes you make in the worksheet (from A1 to D4) also will appear in the Word document.

RESOURCES

Keeping you informed and prepared amid the coronavirus outbreak

We’re gathering the latest news stories along with relevant columns, tips, podcasts, and videos on this page, along with curated items from our archives to help with uncertainty and disruption.

VIDEO

Excel walk-through: Sparklines

Want to liven up your spreadsheets with some color and graphical elements? Kelly L. Williams, CPA, Ph.D., shows how to use Excel sparklines, which illustrate data trends and patterns via small charts that fit in a single Excel cell.