To do this, you'll simply need to begin the cell reference with the worksheet name followed by an exclamation point ( !). The result of an incorrect absolute reference Using cell references with multiple worksheetsĮxcel allows you to refer to any cell on any worksheet, which can be especially helpful if you want to reference a specific value from one worksheet to another.
