Linking Within Workbooks To link a cell to an existing cell on a different spreadsheet in the same workbook, use the format "=SheetName!CellLocation." For example, if your workbook has two ...

How to Link Data on a Worksheet to Another Worksheet in the Same Spreadsheet. Linked cells often make it easier to organize spreadsheet data that's spread among several worksheets.