See subject. 😊
I have a large spreadsheet with hundreds of cells containing formulas with an absolute cell reference (say 12 × $F$1).
(How) is it possible to find and replace this with another absolute reference ($L$2) instead of manually editing every cell? Find & replace doesn’t seem to work with cell references.
Thank you.
If you have no formulas that will still need to reference cell F1, you can lift, drag and drop that cell to L2. and all references to F1 will become references to L2.
If you have no formulas that will still need to reference cell F1, you can lift, drag and drop that cell to L2. and all references to F1 will become references to L2.
It also works horizontally.
The formula =F1 placed in cell K1, then filled right to cells K2, K3, and K4 will increment the column reference by one alphabetical value for each cell, leaving the row reference to row 1.
Regards,
Barry
Fantastic – the most simple and (once you know it…) obvious solution. Thank you!
Replace an absolute cell reference in Numbers?
