Put the steps in order to link worksheet cells. Open both the worksheets. Press enter to link the cell. Select the cell in the destination worksheet. Select the cell in the source worksheet. Enter the formula into the cell.