What will you do if you want to change either the column letter or the row number but not both?
Vishalini.R Answered question July 3, 2023
Using the $ symbol before the row and column coordinates creates an absolute cell reference that will not change.
If you don’t want cell references to alter when you replicate a formula, make them absolute cell references. If you want the column letter to always be the same, put a “$” before it. If you want a row number to always be the same, put a “$” before it.
Vishalini.R Answered question July 3, 2023
