Toggle Between Relative and Absolute References

Use the function key F4 to toggle a reference between relative and absolute references while editing a formula. Repeatedly pressing F4 will cycle through the 4 different options in this order: A1, $A$1, A$1, $A1.If you want to toggle all the references in the formula at the same time, just select the entire formula. The first time you press F4, all of the references currently selected will change