Spreadsheet Tips

Reference Cells Across Sheets

November 26, 2019
A person pulls data from another worksheet in Excel using a cross-sheet reference.

You can create cell references across sheets within your workbook. The format for these kind of references looks like this:

[sheet name] ! [cell reference]

This works for all types of references, including absolute references and ranges.