Working with Special Features

Close Window 

Dragging and Dropping to Link Cells

Use drag and drop to set up a link from one cell to another. You can link cells on the same worksheet, on different worksheets, or in different workbooks.

To link one cell to another, when they are on the same worksheet:

  1. Select a source cell or range (that is, one that has the data you want to link to).

  2. Point at the border of the source. (You’re pointing at the border when your mouse pointer turns into an arrowhead.)

  3. Press and hold down your right mouse button.

  4. Drag the source to the cell where you want to create the link.

  5. Release the mouse button. When the menu appears, select Link Here.

To link one cell to another, when they are on different worksheets:

  1. Select a source cell or range.

  2. Point at the border of the source.

  3. Press and hold down the Alt key.

  4. Press and hold down your right mouse button.

  5. Drag the source down to the bottom of the screen, down to the tab for the worksheet you want to create the link on. When Excel switches you to that sheet, drag up to the cell where you want to create the link.

  6. Release the mouse button. When the menu appears, select Link Here.

To link one cell to another, when they are in different workbook files:

  1. Open both workbook files.

  2. Select Arrange from the Window menu.

  3. In the Arrange Windows dialog box, select Vertical, then OK. Excel arranges the two workbook windows side-by-side.

  4. Select a source cell or range.

  5. Point at the border of the source.

  6. Press and hold down your right mouse button.

  7. Drag the source over to the other workbook, then to the cell where you want to create the link.

  8. Release the mouse button. When the menu appears, select Link Here.

(Posted 6/23/2000)