How to Link Excel Cells to PowerPointby Darryl Brooks
Most everyone knows how to copy something like data in an Excel cell into another program, such as PowerPoint. Sometimes, however, you don't simply want to copy the data but also want to provide a link to the data. In this way, you create a dynamic connection so that when the source data changes in the spreadsheet, the results will also change in the PowerPoint presentation. To do this you use an often-overlooked feature of Office called "Paste Special."
Highlight the cell or range of cells you want to link in Excel, then click "Copy" in the upper-left corner of the menu bar.
Switch focus to the PowerPoint presentation and place the cursor in the location of the presentation where you want the link to appear.
Click the "Edit" menu and then click "Paste Special." In the pop-up menu that appears, select "Paste link." You have now created a live link back to the Excel spreadsheet from the PowerPoint presentation.
- Keep in mind you are not only creating a link to a particular cell or range of cells, but to the location of the spreadsheet. If you move the spreadsheet, you will need to recreate your links.
- "Paste Special" has many useful functions that expand the typical copy and paste operations in Microsoft Office.