In most cases, the default All selection isexactly what you need.Ĭlick the Paste Link button. Make any selections pertaining to the content and formatting you want toinclude in the pasted material. Move to the target worksheet, select the cell where you want the linked data to begin, and choose Edit, Paste Special to open the Paste Special dialog box (see Figure 3.23).įigure 3.23 In most cases, use the All option that's selected by default when creating a paste link. This contentwill become the linked object. Select and copy the source content in the source worksheet. When copying between workbooks, be sure both workbooks are open and havebeen saved. To copy and link content between worksheets or workbooks in Excel, followthese steps: You can establish one or more links within a single worksheet, enabling youto enter repeated information once and have it update to one or more additionalcells automatically. Such a linkuses OLE ( object linking and embedding), a powerful Windowsfeature. What if you want to establish a permanent relationship between the sourcematerial and the target? What if you need to copy a section of a worksheet toanother workbook, and you want changes in the original (source) material toupdate the target (copied) material as well? To establish such a relationship,you must set up a link between the source and the target. If yougo back to the source worksheet and change any of the data, the changes are notreflected in the place(s) to which the material was copied. So far, all the discussion of moving and copying has referred to content thatexists in one or more locations, with no connection between the locations.Copying a section of a worksheet or an entire worksheet to another workbooksaves you time and effort, but after the section or sheet is copied, therelationship between the source material and the target location might end(unless formulas are included that create links, as described shortly).
0 kommentar(er)
