Question

which referencing can be used where only the row or column is fixed​

Answer 1

Answer:

Absolute references

There may be times when you do not want a cell reference to change when filling cells. Unlike relative references, absolute references do not change when copied or filled. You can use an absolute reference to keep a row and/or column constant.