What type of cell reference remain unaffected by the context change when a formula is copied from one cell to another?
Answers
Answered by
8
To change the type of cell reference:
Select the cell that contains the formula.In the formula bar , select the reference that you want to change.Press F4 to switch between the reference types.
Select the cell that contains the formula.In the formula bar , select the reference that you want to change.Press F4 to switch between the reference types.
Similar questions