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.

SPONSORED REPORT

Keeping client information safe in an age of scams and security threats

A look at the Dirty Dozen tax scams and ways to protect taxpayer information.

TAX PRACTICE CORNER

More R&D tax help

"Can I use the R&D credit?" PATH Act enhancements make the credit more attractive to a wider range of taxpayers.

QUIZ

Learn to choose between ‘who’ and ‘whom’

Writers can stumble over who and whom (or whoever and whomever). If you write for business, this quiz can help make your copy above reproach.