Forum Discussion
Cell references absolute or relative
For single Cells, Excel offers two relevant methods of Copying to other locations. The default Copy and Paste commands give the target cell the same formula, with Cell references adjusted. This is n...
My solution would be to lease Microsoft 365 and consign the concept of relative referencing to the trash can of history 🙂
Neither the processing of arrays nor lists in Tables in 365 requires the concept of relative referencing, provided you apply a Name to the Range. On the occasions when terms within the formula do need to be evaluated individually the '@' operator is usually sufficient.