The key F4 is to repeat the last command or action, or cycles through all combinations of absolute and relative references in a formula.
Step 1: Highlight the cell in yellow (e.g., A1);
Step 2: Click any other cell and press F4 from the keyboard.
F4: Repeats Last Command