Click on Replace All and then click on Close. By default, all cell references are relative references.
This will find all instances of Sheet2 in all cells and replace them. Another reader recommended using the F4 function key to toggle between making a cell reference relative and absolute. Make the cell reference of the deduction number absolute, to prevent the cell address changing when the formula is copied. Stack Overflow works best with JavaScript enabled, Where developers & technologists share private knowledge with coworkers, Programming & related technical career opportunities, Recruit tech talent & build your employer brand, Reach developers & technologists worldwide, Change multiple cell references from relative to absolute ($) at once, GitLab launches Collective on Stack Overflow, Podcast 378: The paranoid style in application development. Relative - Relative referencing means that the cell address changes as you copy or move it i.e.
