This is a discussion on Creating A Office Data Shortcut In Office 2007 within the Applications forums, part of the Tutorials category; Creating A Office Data Shortcut In Office 2007 If you often work with data from one program while working inside ...
Creating A Office Data Shortcut In Office 2007
If you often work with data from one program while working inside another Office 2007 program, the shortcut icon is nice because the source data doesn’t get in your way until you’re ready to see it. In addition, the icon loads more quickly than the underlying data would load, and speed can become an issue if your data set is large.
Change the Size of Program Windows
To insert a shortcut from an Excel worksheet to a Word document, change the size of your Excel and Word windows so that you can see both the source Excel worksheet and the targeted Word document.
Select the Cells to Form a Shortcut
Select the cells in the Excel worksheet that you want to link and transfer to the Word document. Press Ctrl-C to copy the cells to your Clipboard.
Select a Special Paste
Click the Word document location where you wish to place the shorcut. Click Word’s Home ribbon’s Paste button arrow and select Paste Special. The Paste Special dialog box opens.
Paste the Shortcut
Click the Paste link option and select Microsoft Office Excel Worksheet object. Click OK to create a shortcut that represents the data.
Test the Shortcut
Double-click the icon. Excel will start, and the shortcut’s data will appear in Excel. The data never combines with the actual Word document’s data. The shortcut acts more like a trigger to display the Excel data in Excel.