Fez R. answered • 04/03/19
Tutor
5
(10)
Experienced IT Professional Specializing in Systems and Networking
The F4 key converts a relative cell reference into a static reference that will not change when you use the AutoFill feature..
Example: if you put =A2 in a cell and use AutoFill, excel will put =A3 in the next cell and =A4 in the next cell and so on.
If you click the F4 key, then excel will change the relative =A2 to a fixed value =$A$2 in the cell, which means that the value for cell A2 will always be referenced and will not change as you use AutoFill.
I hope this helps.
