F4: Repeats Last Command

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.

Check More Excel Shortcuts

Leave a Reply